Create a query merging info from two tables for one report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table which shows basic vehicle information linked to another which
shows vehicle options. When I create a query to show both basic vehicle
information and options, the basic vehicle information repeats on every line
there is an option.

8016 2000 DODGE RAM 1500 RC AC
8016 2000 DODGE RAM 1500 RC AM/FM/CASS
8016 2000 DODGE RAM 1500 RC TINT
8016 2000 DODGE RAM 1500 RC SLIDER

How do I get the report to merge all the options into one field/line so it
looks like this (with a space between each option):

8016 2000 DODGE RAM 1500 RC AC AM/FM/CASS TINT SLIDER

I saw the response to the other person who asked a similar question, but I
do not understand programming language - can you give me simple instructions
for an Access newbie?
 
Sounds like you have a linking issue. Either relink the tables using Tools,
Relationships or re-link the query. There should be a line drawn between the
two tables when you look at them in query design mode. That is your link.
 
The easiest, no code method would probably be to use a main report based on
unique values of your repeating information. Then create a multiple column
subreport to place on your main report. This might be formatted different
than what you would like since the options vary in length.

My preferred method would use the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. There
are samples in the download that show how to use it.
 
Back
Top