Recent content by jp_viper

I guess my mistake was treating Criteria as a WHERE clause then. Is WHERE only available through SQL?

Thanks, I see the issue with how I treated criteria. I made a new field with IsValid: IIf(DateDiff("d",Date(),DateAdd("d",[Task_List].[Interval],[Task_Log].[Date1]))<0.1*[Task_List].[Interval],1,0) and set criteria to 1. Does what I wanted it to. Still, my original issue stands when I tried to...

Greetings. In this query called qryMainList, I am trying to create the criteria on the Equipment_Name field requiring the date difference between today's date and the field called NextDueDate (that I just calculated within the same query) be less than 1/10 of the Interval field. NextDueDate...