Concatenate a list into one field

[ijswalker]

Hi,

I have a list of services that pertain to a client ID. One record for each service with a date the service was performed.

Does anyone know of a piece of VBA code that will concatenate all of the service dates for each client, create a new table and list the result by Client ID based on a selected month?

Thanks

Ian

 

[pbaldy]

Duplicate post:

http://www.access-programmers.co.uk/forums/showthread.php?t=156167