OK, I'm trying to help my daughter with her database homework, and even though I'm doing databases at the moment, I can't work out how to set this up lol.
She has had to set up a database for a library, to show members loans etc..
In the table for loans she has a field for overdue books, one field for 'Date Due Back' and the next with 'Overdue?' she needs to set it up so as soon as the date its due back passes the overdue bit says YES.
Does that make sense? is it possible?
I know you guys are smart! lol any help is appreciated