Hello. I have a question on how I can use a yes/no data type in a
formula. I have a table that uses a yes/no checkbox to indicate if a
fee should be charged or not. In the query, I want to have a formula
that shows the invoiced value multiplied by the mgt fee if the check
box is checked ,otherwise it should just show the invoiced value. The
formula is below.
Expr1: IIf([85% Mgt Fee]=Yes,([Invoiced Value]*[tblMgtfee]![Mgt Rate]),
[Invoiced Value])
The query asks me to enter the parameter value for tblMgtfee- Mgt
Rate.
What is not correct about the formula? I have tries variation of yes
and y etc with quotes but nothing seems to work. The "yes" seems to
work just fine when I use it in other queries an a criteria.
Thanks
Jeff
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
