Search results

I know this is old, but you seem to be active these days. How would I do this?

I'm trying to create an update query that will change the status of residents who live in a building to "Yes" when they have lived there for at least 30 days. What would this criteria look like in datasheet view in Access? Fields would be Move In Date and Approved from a Rooms table.