I am teaching myself access and find I don’t have some of the vocabulary to explain what my issue is. Known unknowns. Anyway I made a dB with a couple of tables in it. I would like to have my table keep every record entered with a date time... then when making a report, it would display the most recent iteration.
My tables etc deal with a high rise appartment. Number of units, up to three parking spots. Storage locker etc. assigned to units
Ideally I could then search back in time to see the state of play on any given date.
1) Does this approach seem sensible?
2) if so, how do I get my table to do that? Atm a modification to the table via the form simply overwrites - updates the record.
Access 2016
Thanks in advance
My tables etc deal with a high rise appartment. Number of units, up to three parking spots. Storage locker etc. assigned to units
Ideally I could then search back in time to see the state of play on any given date.
1) Does this approach seem sensible?
2) if so, how do I get my table to do that? Atm a modification to the table via the form simply overwrites - updates the record.
Access 2016
Thanks in advance