data in query not on report

[Lesley]

I have a query selecting account name, account #, # of deliveries, and time
of delivery. I've built a report on this query as well. However, I notice
on the report that the multiple account numbers and time of delivery (AM/PM)
do not display. It appears that the report is "grouping" the records by
account name or account number (I cannot figure which) and subsequently the
various time ranges per account #, per account are not displayed. I've
looked at the sorting/grouping and that appears to be ok.

Any suggestions???

 

[Duane Hookom]

1) Do you have controls in your detail section?
2) Is your detail section visible?
3) Is there anything in the Filter property of your report?
4) Is there anything your Sorting and Grouping dialog?
5) Have you opened your report's record source in Datasheet view
to count the records?
6) Try adding a text box to the Report Header section with
a control source of:
=Count(*)
Does this display the same number as the number of records?

 

[Lesley]

1) no
2) no
3) no
4) Yes - Account Name (w/ group header); Account #; and Time Range.
5) Yes
6)the display shows the same number as the number count at the bottom of the
report, but not the same record count as the query.

Any other suggestions????

 

[Duane Hookom]

If your report's record source datasheet count is the same as your report's
record count then you problem is with your SQL and not your report. If it is
different then the only reason that I can think of is if you are applying a
filter on the records possibly when you open the report.