>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.
You can pass your date as a parameter in your query.
If it's not broken, fix it until it is.
My Blog