Actually I'm very new in Microsoft access 2010. i have one software which communicating with the Microsoft Access. it just send one line of command to ms access and access will execute. for example for comparison of date I'm using below command:
Code:
Arrival_Date like Date()
the ms access execute this command properly and it compare the Arrival_Date with the current date. the Arrival_Date value format for example is 10/8/2012.
now i want to compare the current time which is return form Time() function with the Arrival_time. the Arrival_Time value format for example is 5:11:00 PM.
i want to check whether the current time is within the Arrival_Time - 30second and Arrival_Time + 30second.
I have used :
Code:
WHERE Arrival_Time BETWEEN Dateadd("s",-30,Time()) AND Dateadd("s",30,Time())
But does not work.
what command should i use to do this comparison in ms access.
appreciate your consideration.