Help!!!!!!!

[4ABs]

I have my access program working fine until yesterday.
One of my queries is not getting the information from the table. Table have 60 entries but the querie stop getting the entries and only have 50. Did somebody know how can I fix this problem???

Thanks,


Alberto

[NassauBob]

Hmm...query returns 50 rows, table has 60. Question: does the query's result set include the freshest (most recently added) table data? If it does, is it possible that your query is set to return only fifty rows? Or, if it does not contain the newest ten records, could the original design of the query be excluding those ten entries? Perhaps the data structure changed, and the query cannot include those rows because of it?

Maybe you could post your table structure and data, and the same for the query, and we could take a look.

Shane