report not showing duplicate records

  • Thread starter Thread starter AnnieJ
  • Start date Start date
A

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.
 
Can you see all the records in the report's record source query datasheet
view? Are the detail controls in the detail section?
 
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
 
Back
Top