Record History

[SLP]

I am trying to create a simple database for printers and
cartridges. What I want to do is track the dates when I
replace the cartridges. I want to continually add new
dates into the same field WITHOUT overriding but adding to
it. Does anyone know if there is a simple way of doing
that with using something like a notes field?

Thanks

 

[Duane Hookom]

Dates should be stored in a date field. If you have many dates, they should
be stored in many records. Think of a record as capturing information about
a single event where it's replacing a cartridge or performing maintenance.

 

[John Vinson]

I am trying to create a simple database for printers and
cartridges. What I want to do is track the dates when I
replace the cartridges. I want to continually add new
dates into the same field WITHOUT overriding but adding to
it. Does anyone know if there is a simple way of doing
that with using something like a notes field?

Thanks

The correct solution is to use Access as it was designed - as a
relational database.

You need TWO tables; a table of Printers, related one to many to a
table of CartridgeReplacements. This table would have two fields: a
printer ID linking it to the printers table, and a datefield. You'ld
just add new records to this table (using a Form with a Subform, for
simplicity) when you change the ink.