Transpose Query

[Bill Sturdevant]

I have records in atable:

R1F1
R2F1
R3F1
R4F1 the number of actual records is variable

I need to do a query and an extract from that query so
that the records come out as follows:

R1F1;R2F1;R3F1;R4F1

How can I do that without writing VB code?

 

[Duane Hookom]

You can let someone else write the code for you. Find it in the Generic
Concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.