Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training+courses - Calculations (expressions) in queries
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access+training+courses - Calculations (expressions) in queries
Resolved · Low Priority · Version Standard
Reply Wed 23 May 2007, 10:44Delegate Sin said...
Sin has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Calculations (expressions) in queries
I have a query with three with three amounts: Ammount 1, 2 & 3. I want to build a calculation in a fourth column that says that if the total from these three is 0, then put the word yes in this 4th column, and if the cumulative total is greater than 0, then put the word No in the 4th column. How do I do this?
For upcoming training course dates see: Pricing & availability
RE: calculations (expressions) in queries
Hi
You can use the IIF function to do this.
Add the below to a new field name in your query.
Expr1: IIf([result]>=0,"Yes","No")
You might need to adapt it to your purpose but essentially:
for example, embed another IIF statement in the false answer part of the statement.
Expr1: IIf([result]=0,"Yes",IIf([result]>0,"Yes","No"))
That should work
Regards
Richard
|