Thread: need to use floor() function in access
View Single Post
  #4 (permalink)  
Old 11-05-03, 09:39
M Owen M Owen is offline
Grand Poobah
  
Join Date: Sep 2003
Location: MI
Posts: 3,713
Okay ... Bad news. Floor is an Excel VBA function not an SQL function ... So for your needs you'll need to do a Between test:

WHERE ( DateDuJour BETWEEN #01/01/2003 00:00:01 AM# AND #01/02/2003 00:00:00 AM#)

You'll need to specify the date and time within the date literals ...
Reply With Quote