I'm back.
Do not use queries too often and have trouble formating a field:
misc: if(([data_order]![order_type])='2';"Normal)";
if(([data_order]![order_type])='8';"Extra")
Basically want it to check the number in the <order_typefield and if
it is 2, type Normal and if it is 8 type Extra.
Thought I could get it to work with IIF, but have not had any luck yet.
Is this even possible? I am sure I have done it before, but cannot find
where.
Please help.
Steven