Search results for query: *

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

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...

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

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

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...

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

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...