I'm creating an access database for our IT Techs to log when they do Windows Updates on our machines. There is a date format field for each record that just has the date of the most recent update. I would like to run a query to show any machine where that date is older than 14 days. I tried entering < Now()-14 into the QBE tool under the date field, but that didn't yield any results. I'm sure this must be doable, I'm just not sure how.
Comment