I think I need a calculation (maybe auto calc) for the status of a library book.
Normally, the book is on the shelf so the default status would be "Available."
If the book is checked out and not overdue, the status needs to be "Checked out."
But if the book is checked and already overdue, the status needs to be "Checked out & OVERDUE."
Also, if the book has been requested by someone else, it should be "Checked out & On Hold."
Not sure how to set this up since one status is based on the date due and the current date; and another status is based on whether or not the book has been requested and needs to be on hold.
Any help would be appreciated.