Concatenating a list of items from a many side table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table created from a make table query. It has two fields: Site_ID
and Date, there are multiples dates for each site ID. I want to create a
table containing two fields (SITE_id, Dates_Ref) with a row for each Site_ID
and a second text field that combines/concatenates the dates for each Site_ID
into a single field (Dates_Ref). Is there a way to do this in VBA.
 
George Neal said:
I have a table created from a make table query. It has two fields:
Site_ID and Date, there are multiples dates for each site ID. I want
to create a table containing two fields (SITE_id, Dates_Ref) with a
row for each Site_ID and a second text field that
combines/concatenates the dates for each Site_ID into a single field
(Dates_Ref). Is there a way to do this in VBA.
Click to expand...

See the function posted here:

http://www.mvps.org/access/modules/mdl0004.htm
Modules: Return a concatenated list of sub-record values
 
Back
Top