OK was not sure if this is the best place to post this. I had another thread where I wanted to concatenate records together on a query and form. I used Allen Browne's method mentioned.
http://allenbrowne.com/func-concat.html
I was able to get this to work well in the queries.
The problem I have now is the query is used in a multi search form.
The search box is really slow in allowing the character input in the form before the search begins.
If I created a temp table it would work much better. I was trying to create an event which will recreate the table on form open. However I keep getting an error telling me the "table is already in use".
Below is an image of the form. the query concatenates the Technician field.
http://allenbrowne.com/func-concat.html
I was able to get this to work well in the queries.
The problem I have now is the query is used in a multi search form.
The search box is really slow in allowing the character input in the form before the search begins.
If I created a temp table it would work much better. I was trying to create an event which will recreate the table on form open. However I keep getting an error telling me the "table is already in use".
Below is an image of the form. the query concatenates the Technician field.