how to look for a date in one table within a range in another tabl

[Gab]

iif [date1] in [date2] - 60 days, "Y" ,"N"
i need to find the first date within the second date - 60 days and then flag
it as N otherwise N,
any ideas?

thanks

 

[Allen Browne]

Try:
([date1] Between [date2] And [date2]-60)

I'm not sure if that's what you want, but it will return True (-1) if found,
False (0) if not, or Null (if either field is null.) You can then format the
result to show a Y or N if you wish.