Incorrect report result

[Leventcos21]

What would cause data to show correctly and competely in a query but not a report. I am filtering a query and when it runs it displays all the records.

On the report it runs onto page 2 any records after page 2 doesn't show. However, my counter displays the correct amount that should show.

Any ideas?

Thanks

 

[dhookom]

What do you mean by "filtering a query" and "my counter displays the correct amount"?

Does your report have anything in the Filter property? Are all the detailed controls in the detail section? Is there any code running in your report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[AlienHost]

I'm having this same problem and don't get it. I have a very simple query: one table that the report is based on. When I go into the record source and run the query, it returns all the data, which is sorted by sequential item ids. However, when I run the report, it leaps from record 1 to record 6. There are supposed to be 41 records, and it only returns nine. There is NOTHING in the query or table to be causing this. Can you think of anything I can do to make the report work better? Could it just be a "corrupt object"?

Here's the SQL behind the query:

SELECT "Item ID: " & [fldauctionid] AS ItemID, tAuctionItems.fldItemDesc, tAuctionItems.fldAuctionID
FROM tAuctionItems
ORDER BY tAuctionItems.fldAuctionID
WITH OWNERACCESS OPTION;

 

[dhookom]

Sorting in a query will not generally pass through to the report. If you want a report sorted, use the Sorting and Grouping dialog.

Make sure your controls are in the detail section and the section is visible. If you still can't figure this out, add two text boxes to the Report Header section with control sources of:
=Count(*)
=[Filter]


Duane MS Access MVP
Now help me support United Cerebral Palsy