J
Joe
I have a database with two tables. Once table list the primary information
and the second table list the maintenance records. Basically, like a car's
Maintenance record where the car stays the same but after ten years the
maintenance records multiple. When I create a query that combines the data
from the two table and displays the data I basically get the following:
Make Date Service
Jeep 3/12/2000 Oil and Filter Change
Jeep 6/15/2000 Oil, Filter, and Air Filter Change
Jeep 9/25/2000 Oil and Filter Change
etc...
What I would like to see is this:
Make Date Service Date
Service Date Service
JEEP 3/12/200 Oil and Filter Change 6/`5/200 Oil, Filter, and
Air Filter Change 9/25/2000 Oil and Filter Change
I want the report in a horizontal report based on the make. Is this
possible in a query? Thanks in advance for any assistance.
Joe
and the second table list the maintenance records. Basically, like a car's
Maintenance record where the car stays the same but after ten years the
maintenance records multiple. When I create a query that combines the data
from the two table and displays the data I basically get the following:
Make Date Service
Jeep 3/12/2000 Oil and Filter Change
Jeep 6/15/2000 Oil, Filter, and Air Filter Change
Jeep 9/25/2000 Oil and Filter Change
etc...
What I would like to see is this:
Make Date Service Date
Service Date Service
JEEP 3/12/200 Oil and Filter Change 6/`5/200 Oil, Filter, and
Air Filter Change 9/25/2000 Oil and Filter Change
I want the report in a horizontal report based on the make. Is this
possible in a query? Thanks in advance for any assistance.
Joe