Record Limit in a datasheet?

I

Indiansquib

I've created a chart the data source for which is a query that has 8760
records. When I view the datasheet for my chart, I can only see 3999 of the
records. Neither the datasheet or my chart are picking up all of the desired
records. Is there a limit on the number of records in a datasheet, is there
a setting I need to update or am I doing something wrong.

Thanks.
 
I

Indiansquib

Yes. There are two tables in the query and both have primary keys. I tried
adding records to my datasheet and it would not allow me to do so. This
makes me think I've run up against a record limit.
 
Top