combining related data into one row of data

[robboll]

Access 2003
If I have a table like this with fields and data like this:
Table1
Acct - Name ------ value1 - value2 - value3
123------Bob------------10-----------10-------10
123------Sue------------10-----------10-------10

How can I get a query result like this?

Acct - Name ------ value1 - value2 - value3
123--- Bob, Sue------20------------20--------20

Any assistance greatly appreciated!

RBolling

 

[Guest]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You could
use this to concatenate the names.

 

[robboll]

There is a generic concatenate function with sample usage athttp://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You could
use this to concatenate the names.
--
Duane Hookom
Microsoft Access MVP









- Show quoted text -

Can you make Access do cartwheels? I wouldn't be surprised!
Thank You again Duane!

 

[robboll]

There is a generic concatenate function with sample usage athttp://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You could
use this to concatenate the names.
--
Duane Hookom
Microsoft Access MVP









- Show quoted text -

What if the values you are using are not primary numbers? FamID is a
number. What if FamID is "ABC"?

 

[robboll]

What if the values you are using are not primary numbers? FamID is a
number. What if FamID is "ABC"?- Hide quoted text -

- Show quoted text -

Duane -- I got your Concat code to work, although the values are text,
not numeric as the code requires. What I did was create a table based
on a totals query of the text values that I am interested in and added
an Autonumber and keyed the text column. Added an autoexec macro to
update any new values on open of the database. In the query I
included this table so that I have a numeric value to use. both the
query and the subquery/Concatinate function use this joining table and
it works very well. Thank you again!

RBolling