Report won't show records with duplicate dates.

[Susan via AccessMonster.com]

When 2 or records have same date in date field, the report excludes most or all of the other record - it printed only one field from the second record in the current attempt. The report is from a query (all records are reflected correctly in the query). Right now, there is no sorting turned on in the query, and "Order by" in the report is set to "no." Changing either of those settings has made no difference. Help!

 

[Duane Hookom]

If you are expecting to see the records in a particular order in the report,
you must set the Sorting and Grouping levels. If you add a text box to your
report Header or Footer section with
=Count(*)
do you see the number that matches the number of records in your report's
record source query?