Muliptiple Records

[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

 

[Lord Kelvan]

i see no duplication of data unless you are telling me you only want
to see the word jeep once i dont see a point in that if you are saying
you want to generate a report that displays

JEEP
3/12/200 Oil and Filter Change
6/`5/200 Oil, Filter, and Air Filter Change
9/25/2000 Oil and Filter Change

then all you do it make a report using the wizard and group it by the
make using the query you already have if you want more you can post
your question in microsoft.public.access.reports if this isnt what you
are looking for please explain it more clearly what you have and what
you want

 

[John W. Vinson/MVP]

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.

See the sample code at
http://www.mvps.org/access/modules/mdl0004.htm
which will let you generate a concatenated string from child table
records.