report not showing duplicate records

[AnnieJ]

My report shows progress of all jobs in production, some jobs have the same
job number and date required but different quantities. I have no problem
adding this detail in to queries and forms but when I run a report the jobs
(with the same job number) will only appear once. Example, job number P1234
has two orders with quantities 3 and 5 due on the 02/02/08, when running the
report only P1234 with qty of 3 is shown. The orders may have been placed at
different times so it is necesary to enter them twice, therefore cannot enter
once as 8.

 

[Duane Hookom]

Can you see all the records in the report's record source query datasheet
view? Are the detail controls in the detail section?

 

[AnnieJ]

I can see all the records in the query. I have just moved the Job number in
to detail instead of groupsheader and the problem is solved. So the report
was grouping by header, it's obvious once it's pointed out. Many thanks