469,934 Members | 1,869 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Help formating a query field

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

Oct 10 '06 #1
1 1114
Fewer parenthesis, commas instead of semi-colons, IIF instead of IF.

If the order_type field is numeric, remove parenthesis from around the 2 and
8.

misc: iif([data_order]![order_type]="2","Normal",
iif([data_order]![order_type]="8","Extra", "Unknown?")

"stevenrec" <st***********@stevenrec.comwrote in message
news:11*********************@h48g2000cwc.googlegro ups.com...
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

Oct 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by serge calderara | last post: by
1 post views Thread by gevayl | last post: by
3 posts views Thread by Tom | last post: by
2 posts views Thread by John Bailey | last post: by
47 posts views Thread by Jo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.