I'm working on an MS Access table..

The timeentry has the format date + time..

I'm using a SELECT * FROM this access table, but how can I filter the data by date only?

Can I use a SELECT directly to the access table, or should I just save this access table to my own dbf, then work from there?

Access table contains all daily log time of the employees.. another program by the fingerscan machine uses this table everyday, every minute..

What's the best approach to do this?

TIA.