Hi Guys,
I would like to thank everyone for their help recently, but another issue.
On my Rental form I have a date out and date in date, the date out is the day the dvd will be rent out, and the date in is the date due back, how can I get a text box to automatically calculate the different between the two, so it says number of days: 3 or whatever, badly explained I know, sorry. After this I will need to create a query to show overdue DVDs, how would I go about doing this, so the query needs to be "Show Rentals that date in is less than current date"
Thanks,
Ryan