query

[Pass-the-Reality]

My table allows for multiple responses. So say I have the below two entries

Name Address Vehicle
Sam 100 Main Street Ford
Sam 100 Main Street Chevy

How can I design a query to combine Ford and Chevy together when column A
and B data match?

Sam 100 Main Street FordChevy

 

[Douglas J. Steele]

You can't, at least not strictly as a query: you'll need to use VBA as well.

See, for example, http://www.mvps.org/access/modules/mdl0008.htm at "The
Access Web"

 

[James A. Fortune]

You can't, at least not strictly as a query: you'll need to use VBA as well.

See, for example,http://www.mvps.org/access/modules/mdl0008.htmat "The
Access Web"

I agree. The query gets pretty ugly when VBA is not used and has a
limit to the number of values that can be concatenated, but it can be
done . See:

http://groups.google.com/group/comp.databases.ms-access/msg/f4c3ff5db206fbe7

James A. Fortune
(e-mail address removed)