Access - Simple way of registering a date an item was audited
I need a simple way of registering the date an item was scanned with the bar-code reader for audit.
It needs to store multiple dates for each item to track its lifetime in school.
I then need to create a statement that flags a tickbox for the record on each asset registered.
I will create a simple form that has a bar-code entry field and a button that commits the record and date to a table, allowing me to audit as fast as possible.
If "date = anydate in 2012"
then "2012flag = true"
How would you create the table to store multiple incremented dates that you can query for a single record?