Conditional display of text in a query result

[Guest]

I have a table like
Person ItemA ItemB ItemC
1 14 1
2
3 2 1 3

From these data, I want to create a query to display results like
Person Item(s)
1 A, C
2
3 A, B, C

(in other words, Item(s) should include display a comma separated list of
any non null items).

I've used IIF in Access for exclusive conditions, but I'm not sure what to
do for items which are not mutually exclusive.

Any advice would be appreciated!

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0008.htm at "The Access
Web", and see if you can modify it for your purposes.