Change (Yes/No)based on date

I’m writing up a database based on a library system.

I have a Date Due Back (Date/Time)

and a Student Library Privileges(Yes/No)

If the book hasn’t been returned after 3 days of the [Date Due Back] then their [Student Library Privileges] will be disabled to, “No”

Now I have a query for overdue books and I want to put this into this query so it’ll display people’s privileges that are gone and all that and I can’t figure out how to do this. Does anyone have any ideas how?

submitted by /u/GuyThatsADuck
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on