Turning query results into string... (1 Viewer)

[wjoc1]

Hello, I have a query that returns a list of courses undertaken by certain employees. They are in the format NPTC CS 30; NPTC CS 31; NPTC 33; NPTC FTC 38; NPTC FTC 40 etc...

Anyway what I need to do with this is convert these results to a string and manipulate them in such a way that they can be displayed in a text box on the back of an ID card in the following format:

NPTC CS 30, 31, 33, NPTC FTC 38, 40... etc.

Because there is not enough room on the back of the ID card to use a subform to just display them in a list...

 

[Uncle Gizmo]

Is this the type of thing you are looking for?

 

[wjoc1]

Ya that looks like the job alright, only thing is that when I try to use your method with my database it gives a compile error with "Dim DB As DAO.Database" saying "Compile Error: User defined type not defined". Any idea what this could be?

 

[Uncle Gizmo]

You need to set a Reference to DAO.

open any code window , select tools, References, and select the Microsoft DAO reference.