Search results

Thanks And thank you both for your time and attention. Very much appreciated. Now to try and implement what you have told me.

Appreciate any help at all.... How would automate changing the Returned Field to Yes based on the presence of a date in the Actual Return date. Also how would I change the overdue field to "Yes" if the Actual Return Date was found to be greater than the Required Return Date. The returned field...

I am developing a library loan application but I'm having trouble with the loans table. The fields in my loan table include Required Return Date, Actual Return Date, Returned (Yes/No) (so I can run queries aginst this table to determine books that are not returned and overdue) and Overdue...