Basic query question (1 Viewer)

[marleyuk]

Hello, i have a small database thats purpose is to show when a book has been returned to me. I am recording the date that books are loaned out. Books are loaned for a 2 week period. I dont know if it would be easier to just manually put in the date that books should be returned (so that means just manually calculate what the date will be 2 weeks later). The reason for this is because i want a query that shows when the date has passed and how many days overdue the book is. Would this be difficult to achieve? What i was thinking is a query that calculates when the 2 week period is up and adds the unique number for book in a report.

Can anyone help?

Thanks,
Marley.

 

[CEH]

In your query add a field..... Something like "ReturnDate"
ReturnDate: ([LoanOutDate]+14)
That will add 14 days to the "LoanOutDate"

You'll need a little more if your looking to work with holidays and or weekends. Those require some coding.... But just a simple 14 days is..... simple

 

[neileg]

Actually, if the loan period is always 14 days, you don't ever need to store the return date as it will always be the loan out date plus 14. You can calculate this any time you need it.