Querie Error

[googalabosh]

I apologize for not being able to publish a portion of my database or talk about in great detail. I will do my best though.

How the database works:

1) Main table contains records with the following data: ID#, Name, Date of record

2) 3 Queries split up the main table:
1-All record 60 to 90 days
2-All records 90 to 150 days
3-All records 150+

3) The queries are then input into a report

Recently the 3 queries started including other records that are not valid to the query. Additionally, these "extra" records aren't even complete. The only field that is filled in is the Name field. All of the queries do contain the right records, however, they each have some these "incomplete extra" records.

I've compared all the queries, the records, and the table to find some kind of common denominator but I am unable to find one. I've done a "compact & repair" hoping that would fix it but it didn't help either. The only "possible" connection I can see between these "extra" records is that all seem to span about a 30 day period in between two months.



I'm looking for ideas of things to check. Please keep in mind that I'm still new to Access (about 3 months of experience),however, I am an expert with Excel (10+ years).

I appreciate any all help with this.

[pbaldy]

What is the data type of the date field? If it's text, you could see wonky results. If it's date/time, what does the criteria of an offending query look like?