displaying mulitple fields on one text box

[sthapa]

Hi im wondering if you can advise me on the best way to do this;

I have 7 fields in a table that record a specific reference code the customer quotes to us. Of these 7 fields only 1 will ever be ticked(yes/no). I need to have a textbox on my report that shows what reference code the customer chose, rather than have textboxes for all 7 fields.

i apologise if this is an easy thing to do but im quite new to access.

Thanks in advance

 

[maxmangion]

do you mean that in your table you have 7 different fields all referencing the same code ?

 

[sthapa]

no the fields are just yes/no tick boxes and each of those fields will pertain to a different code

 

[jv2]

I would probably do it in the "on load" of the report... just check which tickbox is ticked... then change the value of a label or textbox accordingly to display the code that the tick is referring to...