Concatenate into multiple columns (1 Viewer)

ChrisO

Registered User.
Local time
Tomorrow, 07:45
Joined
Apr 30, 2003
Messages
3,202
Question from post #48: -

>>or i have to create the query and use the function to see the results?<<

No, but you could use the download available in post #18 where the code builds the table tblDestination and then run a query off that table for your report.

Sounds like an interesting report. :)
 

lala

Registered User.
Local time
Today, 17:45
Joined
Mar 20, 2002
Messages
741
Its freaking horrible. Its due tomorrow and I'm nowhere near done. Just left work (got kicked out by the cleaning crew))) and will be up all night trying to finish from home

You, guys, saved me a bunch of time. There's 7 sets of 5 sets of columns that have to be spread out like this. I had a way of doing it with 4 queries for each set, so 35 times 4
Now its only 14 thanks to that amazingly simple one query way

I will study yours, chris, and the 4 other examples here just to learn once I'm done with this atrocity))))))))

Thank you all so much
I can't praise this forum enough
 

Users who are viewing this thread

Top Bottom