Missing record on report

[DougieJ]

I have a query which returns 6 records, but the associated report only prints 5. Exporting the query to Excel gets all six records. Creating an entirely new report on the same query returns only 5 records. Creating a query which uses the original as input shows only 5 records. It is always the same record that is omitted. Any ideas?

[Gina Maylone]

Is there a second page to the report where the missing record might be?

[DougieJ]

No. I've fixed the problem without being sure what caused it. It may have been something to do with duplicate keys on an ODBC linked table.

[Gina Maylone]

Good, glad you got it figured out!