Can this one be done

[Shop Girl]

I have a query which summarises the totals on a receipt. Put simply it looks up each entry for the ReceiptID and outputs to one line the sums I have asked it to do using the Group By method - which for me is quite an achievement!

Taking it one step on, is this possible...

On each receipt the purchaser could have bought items from several categories eg Trousers, Bags, Underwear... the list is endless. Can I get my query to put into one output field the list of all the categories that are attributed to that one ReceiptID?

I could even live with the query listing the category once if there is only one item on the receipt and then saying "Various Clothing" if there were several.

 

[Fornatian]

In the words of our dear Pat Hartman...

It's time to get your feet wet. VB is required. Look up this article in the knowledge base:

Q141624 - ACC How to Concatenate a List of Items from a Many-Side Table

and strangely enough the post she answered where I got this from was called "Can it be done"

 

[Shop Girl]

Thanks

Thanks for your help!

Searching works better if you know what you're searching for!