Search:

Type: Posts; User: nthayer; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    8
    Views
    709

    Yes, here it is (tPracGroup00 is my table that I...

    Yes, here it is (tPracGroup00 is my table that I make and tQuery5a is the table I imported):

    SELECT tQuery5a.tkinit, ([tksect]*1) AS tksect1 INTO tPracGroup00
    FROM tQuery5a;
  2. Replies
    8
    Views
    709

    I imported a table (so that is static for number...

    I imported a table (so that is static for number of records); queried on that table (no parameters - just everything for result); got results which were saved in make table; repeated; yet each time...
  3. Replies
    8
    Views
    709

    There are no macros upon open; I just run the...

    There are no macros upon open; I just run the queries and open the report; we are on 2003 SP3. Thank you,
  4. Replies
    8
    Views
    709

    I have a database that grows exponentially when I...

    I have a database that grows exponentially when I run it and the compact/repair tool does not decrease the size. I even tried just running it without changing any of the query parameters so that the...
  5. Replies
    2
    Views
    305

    Re: Setting Table Field Widths (2003 sp2)

    Good catch - I have several appends to that table, and in testing, I undid the append. Sorry to waste your time, but now it works. Thank you so much,
  6. Replies
    2
    Views
    305

    Setting Table Field Widths (2003 sp2)

    I have created a table with specific field widths (all text). When I run the macro to delete from the table and append new data, all my columns revert back to 255. How can I keep the table column...
  7. Re: Running Sum without Unique Record (2003 SP2)

    Sorry for the delay in my response - I was pulled away on another project, but I wanted to thank you. As usual, you have saved the day and taught me something new. Thank you so much, Norma
  8. Re: Running Sum without Unique Record (2003 SP2)

    Yes, if you change the clienttotalwip Footer to visible, you will see the cumulative total for each baty, client. This lengthens the report, but starting on the new page 256 for baty# 01391 starting...
  9. Re: Running Sum without Unique Record (2003 SP2)

    Thank you so much for your efforts. The gist of the problem is that I am trying to show the % of the Client WIP Total as I display them in descending order for each person's ID#. But when the...
  10. Re: Running Sum without Unique Record (2003 SP2)

    Actually I only included the group sorts that are on the report in order to summarize my problem. There are actually many lines that make up the client totals (in other words, for each clnum, there...
  11. Running Sum without Unique Record (2003 SP2)

    I have a table that I am using in a report (see attached Excel sample). I want to sort by baty, clientwiptotal, then clnum while calculating a running sum of the clientwiptotal for each baty. I...
  12. Replies
    8
    Views
    409

    Re: Running Sum in Group Footer (2003 SP2)

    I actually have four group sorts so I made another running sum and changed the code appropriately. It now seems to be working. Thank you both so much!! Norma
  13. Replies
    8
    Views
    409

    Re: Running Sum in Group Footer (2003 SP2)

    I set it to Over All because if I just do the Over Group it doesn't calculate properly. - it just gives me the same total as the field. My report sort is by person, then clients (that's the running...
  14. Replies
    8
    Views
    409

    Re: Running Sum in Group Footer (2003 SP2)

    That works for the first person in my group, but the txtTotal stays the same for the next person in the group and I need that to start fresh with the new threshold value. Now my report prints...
  15. Replies
    8
    Views
    409

    Running Sum in Group Footer (2003 SP2)

    I am showing detail for a group that keeps a running sum on an amount field. I have calculated a % threshold in a field and when the running sum goes over that $ amount I have made the line not...
  16. Re: Suppress Fields in Page Heading (2003 SP2)

    You were right - it was complicated and tricky, but I was finally able to get it. Thank you so much!!
  17. Suppress Fields in Page Heading (2003 SP2)

    I have a report grouped by person. I have inserted a subreport in the group heading that shows summary totals and page breaks before and after. The detail section then shows the data to support...
  18. Replies
    6
    Views
    394

    Re: Subtotal for Top 20 (2003)

    I figured out the problem. My 2nd page had less than 20 lines so it kept the prior running sum. I changed it to <= 20 and now it works. Thank you so very much.
  19. Replies
    6
    Views
    394

    Re: Subtotal for Top 20 (2003)

    Yes, I just doublechecked again and the detail txtRunSum is set to Over Group for running sum. I even made txtRunSum visible for now to see if it was recalcing on the new pages, and it is but the...
  20. Replies
    6
    Views
    394

    Re: Subtotal for Top 20 (2003)

    Thank you Hans for your suggestion. I see what you are doing and that makes sense. However, the txtSum continues to be the same number when my report goes to the next Name instead of resumming the...
  21. Replies
    6
    Views
    394

    Subtotal for Top 20 (2003)

    I have a report that groups by Name, then Sales. I only want to show the Top 20 Sales clients for each Name, so I am using a counter that hides the Detail section when counter > 20. However, I want...
  22. Replies
    1
    Views
    267

    Repeat column when printing (2003)

    Is it possible to repeat certain fields when the data goes over one page on a report? I'm trying to emulate the 'Columns to repeat at left' option that I use in Excel for an Access report that has a...
  23. Replies
    6
    Views
    432

    Re: Page Suppression (Access 2003)

    Thank you so much Hans. You are right about changing the value - as I change formats, etc I do need to modify. You have inspired me to sign up for a VBA class. I can see that I need to get to the...
  24. Replies
    6
    Views
    432

    Re: Page Suppression (Access 2003)

    Thank you for your kind offer - I have attached the database. The first page ifor Administrative Law is fine since it only has 4 records, but the ADR and Banking and Lending exceed the 49 records I...
  25. Replies
    6
    Views
    432

    Re: Page Suppression (Access 2003)

    I admit that I am not that great with VBA. Where can I find more information about the Function Printlines? I followed the steps, but the additional pages are not suppressing. Thanks, Norma
Results 1 to 25 of 37
Page 1 of 2 1 2