<Li****@magichans.com> wrote
We need to track how often a
book has been loaned. We enter
the dates and need an automatic
calculation how often in the pre-
ceeding 12 months it has been
taken out.
box 1: today's date box 2: loaned n+1
How do I go about this please?
If you will clarify what data you _keep_ about the book and loans, not just
what you want to _return/calculate_, someone may be able to offer a useful
suggestion.
If you only have one record per loan and it contains the checkout date,
you'll insert today's date as criteria for the date field, and use the count
function on a field that is not null in any record... but you may be using
different information to track book loans.
Larry Linson
Microsoft Access MVP