Listing more than one date in field

  • Thread starter Thread starter Kari
  • Start date Start date
K

Kari

I'm trying to create a database which will show all
maintenance completed on our company vehicles. I want to
be able to list more than one date in a field, showing
date it was completed.
Example: Vehicle # Oil Change Air Filter
828-8703 5/5/03 5/5/03
7/8/03 7/7/03
10/10/03 10/5/03

828-8703 5/5/03 5/5/03
But I would like to be able to do this in the table so I
don't have to create a query for each piece of equipment.
Is there a way that I can change the data format in the
field to list more than 1 answer?? Anyone's help would be
greatly appreciated. Thank you
Kari
 
Sorry, but you can't. Relational database theory doesn't allow a single
field to have more than one value, therefore Access doesn't allow it either.
 
Kari,
To expand on Doug's note:
You should design your table like so:
VehicleID, ServiceType, DateOfService.
828-8703 5/5/03 Oil Change
828-8703 5/5/03 Air Filter
828-8703 7/8/03 Oil Change
828-8703 7/7/03 Air Filter
828-8703 10/5/03 Oil Change
828-8703 10/10/03 Air Filter
Databases are designed to store data in very efficient ways and, believe it
or not,
the format above is efficient.

Your format is a more efficient way of *Presenting* data, and it is a simple
matter to create a report that
presents the data in any way you want it.
Consider a presentation like this

-----------------------
Date OilChange AirFilter
Vehicle: 828-8708
5/5/03 X X
7/8/03 X
7/9/03 X
-------------
Vehicle 123-4567
5/6/03 ...

So, get your data in this format and come back here to find out how to
present it.

HS
 
Back
Top