Query based on one table not returning values for date

[westfallbp]

Have a table called Tauction and I have a Date field called auctionDate. I then based a query on that table called QAuction

In the query I have the AuctionDate field in there just by itself to seed if would return only those records for todays date, (There are records in the table with todays date if your wondering) I put in the criteria for the field in the query Date() it only returns 1 record where It should have returned 6. Am I using the right syntax Date(). I even went to the table and set it to index yes Duplicates yes. Cant figure this out and only assuming it shouldn't be Date(). Help would be appreciated. Thanx Ps. It does however work with a perimeter query when in the criteria [Enter Date]

[Micron]

You're saying that you have 6 records in the table that have today's date? If Date() returns only 1 record, then the other five records are different somehow. That field is Date/Time data type when you look at the field properties in table design view? And you're entering dates only and not time as well?

[Gicu]

Try wrapping the AuctionDate field in DateValue() to strip the time component and use Date() in the criteria row.
Cheers,

[Welshgasman]

I would go with a Time element as well.

[westfallbp]

You're saying that you have 6 records in the table that have today's date? If Date() returns only 1 record, then the other five records are different somehow. That field is Date/Time data type when you look at the field properties in table design view? And you're entering dates only and not time as well?

I resolved the issue, I looked in the table and the field was set to Date extended