Ken Rules!!
Ken, that is exactly it. I don't know how to thank you? I have about 3 different tables similar to the medications table that require the same thing. Now I can adapt the situation for all of them since you have put me on the right course. I can't even start to describe how happy...
here is a db with a medications table in it. I'll also check out that knowledge base file. I really appreciate the help. I've been racking my brain trying to get this to work.
I'm trying to concatenate multiple record field items to another table/query (with the purpose of exporting them to another program). I'm a seasoned Access person with limited visual basic knowledge. Any direction or suggestions would be appreciated.
My table/query is as follows;
Client ID...