Access-Database that accumlates & doesn't overwrite

[bjllady3333]

I am trying to create a data base for equipment at our company. I can create the table etc. but I do not know how to keep the new information from overwriting what is already there. For example I want Loader #1045 to have the oil changed on 1/28/03 and again on 3/28/03 and I want to bring up the table I have created to enter information in. Enter 1045 and all the information for service on that date and hit enter and have it ADDED to what is already in the record- NOT overwrite what is there already.
I also want to be able to do querys by the last information entered. Such as all machines that have had 1000 miles put on it should print out.
Am I asking too much? Please help
bjllady3333@go.com

 

[Corticus]

Hi bjllady,

Sounds like you need a new table for maintenance. It could be set up like:

TblMaint
MaintID - autonumber - primary key
MachineID - number
this is where the ID for loader #1045 etc would go
ServiceTypeID - number
oil change or whatever
Date - date
when the service was performed

See really, you want the machine associated with a maintenance record, not as a field on the machine table.

Data as follows demonstrates multiple services for one machine:

Book2
	A	B	C	D
1	TblMaint
2	MaintenanceID	MachineID	ServiceTypeID	Date
3	1	1045	1	1/1/2003
4	2	1045	2	2/1/2003
5	3	1045	2	3/1/2003
6	4	1050	1	1/2/2003
7	5	1050	2	2/5/2003
8	6	1051	1	1/3/2003
9
10	TblServiceType
11	ServiceTypeID	ServiceTypeDescription
12	1	oilchange
13	2	generalcleaning
Sheet1

As far as your query goes, create a new query, add the machine table, and enter into the criteria under milage, [enter mileage].

Now use the wizard to make a report based on this query. Now when you run the report, Access will prompt you for the mileage, and you could enter 1000, or whatever.

HTH,