Combining Records

[Guest]

Hi All

I have a query set up which currently contains three records. I would like
to be able to add an expression which shows the results of a particular field
summing all three records.

Example;

The three records show the same fields except the Abbreviated Name field
which is different for all three. I would like the query to show just one
field with the three abbreviations shown in the one record seperated by a
comma.

Instead of;
Record 1
JD

Record 2
MC

Record 3
PD

I would like;
Record 1
JD, MC, PD

Any ideas?

Mikee

 

[Guest]

Look at this answer given by Duane Hookom on the same subject

"You can use the generic concatenate function found at "
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. Your
control source might be
=Concatenate("SELECT DISTINCT PartName FROM qryInv WHERE CatID = "
& CatID)

 

[Guest]

Thank you very much Ofer, that was of great help.

Regards
Mike