Update to specific Date!

[MarkNie]

Hi All

This is a follow up on the Count Records in an update query.

What I am trying to do is once I can get the count function working right, I would like to update this to a tbl with a date field which is automatic. It should update only the records on todays date and not any previous dates.

This is for stats and I need to run the query at least 3 times a day as the stats change through the day. So that at the end of the day I have the latest stats without having multiple date entries in my table. Thus it should only update todays date.

If you know of anyway that this is possible that would be great.

Thanks again
Mark

 

[PHV]

DELETE FROM ytblPerformanceSummary
WHERE Int([PERFORMANCE Summary of Deadlines])=Int(Date())
AND [PERFORMANCE Summary of Deadlines] <> (SELECT Max([PERFORMANCE Summary of Deadlines]) FROM ytblPerformanceSummary WHERE Int([PERFORMANCE Summary of Deadlines])=Int(Date()));

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886