Maximum number of records shown in a report

[gaker10]

I have a query returning about 450 records. However, the report that is generated from this query only shows about 113 of them. Is there a limit to the records on a report?



I use a report for this query for calculation/aesthetic purposes.

Also, my report actually contains two reports into one, but the second "sub-report" has a relatively small record count. The first "sub-report" can be quite large (the report that only shows 113 records).

[JamesDeckert]

There is no limit on the report. It's likely that you've created an inner join (the default) on the report that is based on a query that uses your first query. You're probably only seeing records on your main report which have records in your sub report. The way to change this is to right click your join line in the record source for the report and select to show all records from the table on the main report and matching records from the table for your subreport

[June7]

Only limit may be memory. Must be report design issue.

If you want to provide db for analysis, follow instructions at bottom of my post.

[gaker10]

My apologies, but my problem actually stems from incomplete data on a spreadsheet.