IF with Dates Query

[dring]

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!

[ranman256]

if this is used in a query:

iif(([time1]<=[time2]) and ([time3]<=[time1])),1,0)

[dring]

if this is used in a query:

iif(([time1]<=[time2]) and ([time3]<=[time1])),1,0)

This worked, Thanks!