Stupid Question (Perhaps) Group and list in a query (1 Viewer)

[GaryPanic]

OK I have an number of records (transaction) in different currencies (and different tax rates just to make it interesting )

so lets assume I have 20 USD transactions and 3 tax rates
Great I can group and summerise
10 at tax rate 5%
5 at 12% rate and
5 at 21.25% tax rate
3 lines in my group query

can you group and have the last field -list the (in my case transaction number)
so USD 10 at 5% then the last column (called trans ) have them listed with a seperator (so 123, 125,128,154,127,130, etc) or am I being a wally?

 

[theDBguy]

Hi. I think you can by using a custom function like this one.

Code Snippets

www.accessmvp.com

 

[GaryPanic]

THank you (You always seem to be so helpful on the occasions that I have a panic attack.!!.)
I now have to read this and understand it - which will be interesting lol

again thank you

 

[theDBguy]

THank you (You always seem to be so helpful on the occasions that I have a panic attack.!!.)
I now have to read this and understand it - which will be interesting lol

again thank you

You're welcome. Let us know how it goes or if you have any questions or run into any issues. Cheers!