Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PJShows

    Getting Grand totals adding two sub reports totals

    Thanks for the suggestion but that didn't work. i'm afraid I need to have some type of relationship.
  2. PJShows

    Getting Grand totals adding two sub reports totals

    I have two sub-reports. sub-report1 with 4 colums AmountDue, Discount, Interest and Total. On these colums I'm getting group totals and over all totals. I have the same colums on sub-report2. I need to grab the over all totals from both sub-reports and add them together. They look like this...
  3. PJShows

    Group by in Reports not working

    In the type of reports I'm doing and with the power of the servers I have backing it up the sorts I have in the query are correctly placed. They are required to be able to get the results I'm looking for. But I do thank you for your responce
  4. PJShows

    Group by in Reports not working

    Thanks I found the problem, Groups have to be set in this query as well as in the report. It was pulling the groups in the wrong order from the query. once I correct the order problem solve. Just had to beat my head to wall for a while
  5. PJShows

    Group by in Reports not working

    I have two reports. One shows paid Dist and one shows unpaid dist. I'm grouping by a group code which is a number assigned to each group. On the unpaid report every thing works fine on the paid however the grouping does not work. Just some back ground on what I've check. In the query I...
  6. PJShows

    Sub-Reports

    OK, I see what your saying about creating the form. But are you saying put the text box as the criteria in they query?
  7. PJShows

    Sub-Reports

    Is it possible to have a report that pulls information from two sub-report but type the criteria in once. IE: if both query's have Between[Start date] and [End Date]in the criteria. Right now when I run the report you have to enter these areas in twice. Once for each query that runs. I want to...

Part and Inventory Search

Back
Top