If i have a table with most of the fields in ti being list boxes (yes/no) is there any way I can show only the fields with a 'yes' in a report.
One of the fields is
Discharge_meds_digoxin
If the list bix option is 'yes' I want to have in the report 'Digoxin' as opposed to 'yes'?
I have thought of a long winded approach i.e.:
Digoxin: IIf([Discharge_meds_digoxin] = "Yes","Digoxin","")
but with so many fields this would take ages in a query surely
One of the fields is
Discharge_meds_digoxin
If the list bix option is 'yes' I want to have in the report 'Digoxin' as opposed to 'yes'?
I have thought of a long winded approach i.e.:
Digoxin: IIf([Discharge_meds_digoxin] = "Yes","Digoxin","")
but with so many fields this would take ages in a query surely