I have a problem, i have a report that details payments made on certain dates. when i run the report, i should get the company name, payments made, and the date the payments were made. If there is more than one payment made, these extra dates and payments should be listed below the company name, and chronological order.
However, this doesn't happen. when i run the report, i am only getting the first payment and date, and then it moves to the next company name, and lists only one payment and date.
I ran the query and it gave the correct results.
Is there a reason why this would be happening?

Thankyou

Its the way you have your report set up. Your company name should be positioned within a "Company" Group Header line. Your payment details, such as date and amount should be reflected within the detail section of the report. You can assign a "Company" Group Footer line, which will enable you to sum the payments for an individual company. To achieve this, go into the properties section of the report, while in design view and click on Sorting and Grouping.

I had already tried that, but it was no use.
Thanks anyway.

Anita

Post the SQL of the reports query

It's ok thanks, i re-created the report by making a few changes, and it now works. Thanks anyway.

Anita