Need some help on this one: Combining two records into one

[Guest]

Combining two records into one.

Any help on if this is possible would be greatly appreciated.
I am pulling data similar to what is below.

Record1: John Smith November cl
Record2: John Smith December ch

What i need is for these 2 records to be combined to:
John Smith November cl December ch

This data needs to be displayed at one time on a form and I am unable to do
it unless it is all part of one record.

I have thought of taking 12 queries (1 for each month) and then a 13th to
put the 12 together, but thought there has to be a better way.

Any help will be usefull. Thanks

 

[[MVP] S.Clark]

Duane Hookum's concatenate function can help.
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
Click on:
Generic Function To Concatenate Child Records


You could mash the Month and Code together, then pass that to the
Concatenate function

 

[Guest]

Thanks,

I think that this is going to work.

Duane Hookum's concatenate function can help.
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
Click on:
Generic Function To Concatenate Child Records


You could mash the Month and Code together, then pass that to the
Concatenate function