I have a table that has a row entry for each userID. I need a way to display each userID on one line in a query. Data is set-up like this
I want my output to be like soCode:userid logonstation 123 e12ac 123 rst22 123 ffk8 456 99a 456 781e 789 r289 789 n11 789 n132 789 n08 789 n22
How can I use a standard query or even VBA to be able to have query results display like the above?Code:userid ls1 ls2 ls3 ls4 ls5 123 e12ac rst22 ffk8 456 99a 781e 789 r289 n11 n132 n08 n22