Recent content by EcolabDan

Experts, Thank you. I was able to look at the date differently due to your suggestions and limit my data. Then I was able to re-write the IIf statement to capture everything I wanted. This is solved. I know you can mark forums solved, but I am new and can't see how to add the solved...

Hello Experts, I work for Ecolab and utilize a variety of data and I am starting to manage this data with Access 2007. I have hit a roadbump in my learning around a failing immediate IF statement in a query that someone else wrote that looks like this, that I do not know how to correct...