Need help with queries

[Haz]

I need help with location query.

I have a table of three fields

Location
Item
Qty

I want a query or report to display locations of an item in one field instead of multiple records.

Data:
Loc Item Qty
N024 AA77 88
N025 AA77 87
N026 AA77 28
N038 AA77 89
N039 AA77 25
N44 BB77 100
N46 BB77 0
N50 BB77 22

Output For example

N024,N025,N38,N39 AA77 88

It's okay if the qty is wrong I might not need it at the moment. Most important is the location.

Thanks

 

[neileg]

Try this post:
http://www.access-programmers.co.uk/forums/showthread.php?t=158320&highlight=concatenate+side
Otherwise search for 'concatenate' in these forums for lots more help.

 

[Haz]

Thanks a lot, I did a search for 'concatenate' and found this sample database which is similar to mine. Works great!

http://www.access-programmers.co.uk/forums/showthread.php?t=74272&highlight=concatenate+records