Modifying display of report items

[Humlan]

Can't seem to find out how to summarize several table fields into a single report field. I have several Yes/No fields:
Category_Games
Category_Movies
Category_Other

...that I'd like to summarize into one report field that displays something like:
Games, Other [/color blue]

...i.e. writing a text separated by symbols based on the values of several table fields.

Probably a piece of cake to do, if I only knew how...

Thanks in advance!

/Jonas

 

[Humlan]

Ahh, found a way:

=IIf([Category_Games]="-1";"Games ";"") & IIf([Category_Movies]="-1";"Movies ";"") & IIf([Category_Others]="-1";"Others ";"")

/Jonas

 

[dhookom]

You table is a bit un-normalized. However, you should be able to s
=IIf([Category_Games];"Games ";"") & IIf([Category_Movies];"Movies ";"") & IIf([Category_Others];"Others ";"")

At a minimum, don't place quotes around the -1 since your fields return either 0 or -1 as numeric values, not text.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.