Missing Records from report

[pp8082]

Hello,
I am using Acess 2000
I have a table with 5,386 records in it .
It is not linked with another table and has no primary key.
It is a stand alone table.
When I do a query , all the records appear
code:
SELECT [DateDaily], [sw], [c]
FROM Signals;


If I use this query for a report only 5,136 records appear.
The last 250 will not display.

What is going on? I can't figure this out.

Thanks

 

[pwbrown]

What if you try:
SELECT *
FROM Signals

 

[pp8082]

I tried SELECT *
FROM Signals

Did not work. Same result

 

[JHB]

Hello,
The last 250 will not display.

Do you mean the exact last 250 records?
Make a copy of the table and delete the first 250 records, to se if some of the missing records now show up!

 

[pp8082]

I deleted the first 250 records .
Now the last 250 show up.

So what is the problem. ?
Why can't I see all the records in the report ?

 

[JHB]

If you use a ODBC connection to a database or gets data from a SQL database, then a queries have a MaxRecords Property, which can be set.

If not then try to import the table and the query in a new database.

 

[pp8082]

This is an Access Data Base.
The data for the report is generated by vba code.
The code loads the date and an indicator into the table.
There is a record for everday since 1/1/1991 throught 5/18.2012.

There has to be an answer for this .

 

[JHB]

This is an Access Data Base.

Do I to understand the above such that a database with an ODBC connection or connected to a SQL database isn't a MS Access Data Base, that is new for me.