Yet another access question

[aceizace]

OK, i vow this will be my last. I have a table that has 'date loaned' and 'date due back'. 'Date loaned' has a default value of Date() so that when you 'loan' an item it has that day's date in, and you can type in when it needs to be back. How will i make something so that it will tell me when an item is overdue? It can be a query that when run it shows all the overdue items, or it could just be another field that has some sort of formula that works out whether it is overdue or not. Whatever will work! Thanks.

[rinkytink]

Presuming that you are using a form for data entry the simplest way to do this would be as follows.
Create a text box on your form called for example 'Days Remaining', make it's data type a number.
Set the control source of this text box to be whatever your date due back field is called minus your date loaned field. Like this:

=[Date Due Back]-[Date Loaned].

The box will then countdown the days remaining for each loan. You can then set up some sort ofr message box to trigger when a loan reaches 0 days.

[aceizace]

How would i make the message box that comes up when an item is less than or equal to 0 in the form? Thanks