Hello Richard,

If the goal is to retrieve records for today, why not using the Date() function?

SELECT Activities.Unique_ID as Activity,
...
FROM (Activities
...
WHERE ...
AND (Activities.Start_Time = Date())




You might also want to have a look at some other date functions available to you in Access

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acrefComparingVBSQLServerFunctions.asp

Hope that helps,
Alex