Hi All,
This is my first post as I am new to using Access and am having a difficult time with a query to set a 1 or 0 dependent on 3 time fields. This is what I'm trying to get from the Access query.
IF Time.1<=Time.2 AND Time.3<=Time.1 return 1 Else 0.
The fields I'm working with are in the format of MM/DD/YYYY HH:MM:SS.
I sincerely appreciate any help provided!