Recent content by siberianfox

Wonderful, it works perfectly. Thank you very much!

I'm trying to build a Query that looks at expiration dates, but only displays them if the date is equal to, or less than, 30 days from the current date. The structure: PTAC is the name of the field in which the user enters the start date. Expr1 is the name of a calculated expiration date...

Thank you. Yes, I forgot to mention that these tables were being manipulated via forms, however this solution looks perfect. I'll give it a try, thank you very much.

Hello! To start, this is the first Access project I have ever done. I am literally sitting here with a large book about Access, and tons of paperwork that will magically become a database. All in all, I don't feel completely lost, but I can't seem to grasp proper table relationships. Basically...