Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IIF formula problem

Status
Not open for further replies.
ksimmsa

ksimmsa

Programmer
Feb 6, 2004
22
US
i'm trying to create a formula that is the following fields do not total more than two enteries that is will caculate zero.


AvgValue1: (([Monitoring]![Sup call 1a])+([Monitoring]![Sup call 2a])+([Monitoring]![Sup call 3a])+([Monitoring]![Sup call4a])+([Monitoring]![Sup call 5a])+([Monitoring]![Sup call1b])+([Monitoring]![Sup call2b])+([Monitoring]![Sup call 3b])+([Monitoring]![Sup calll 4b])+([Monitoring]![Sup call 5b])+([Monitoring]![QC Call 1c])+([Monitoring]![QC Call 2c])+([Monitoring]![QC Call 3c])+([Monitoring]![QC Call 4c])+([Monitoring]![QC Call 5c])+([Monitoring]![Trainer Call 1d])+([Monitoring]![Trainer Call 2d])+([Monitoring]![Trainer Call 3d])+([Monitoring]![Trainer Call 4d]))= < 2 then 0

thanks in advance for your help...
 
Sort by date Sort by votes
This syntax expresses the concept "If the sum of these fields is less than three, then the answer is zero. Otherwise, the answer is the sum of these fields."~

AvgValue1:
iif(
[Monitoring]![Sup call 1a]+
[Monitoring]![Sup call 2a]+
[Monitoring]![Sup call 3a]+
[Monitoring]![Sup call4a]+
[Monitoring]![Sup call 5a]+
[Monitoring]![Sup call1b]+
[Monitoring]![Sup call2b]+
[Monitoring]![Sup call 3b]+
[Monitoring]![Sup calll 4b]+
[Monitoring]![Sup call 5b]+
[Monitoring]![QC Call 1c]+
[Monitoring]![QC Call 2c]+
[Monitoring]![QC Call 3c]+
[Monitoring]![QC Call 4c]+
[Monitoring]![QC Call 5c]+
[Monitoring]![Trainer Call 1d]+
[Monitoring]![Trainer Call 2d]+
[Monitoring]![Trainer Call 3d]+
[Monitoring]![Trainer Call 4d]
< 3,0,
[Monitoring]![Sup call 1a]+
[Monitoring]![Sup call 2a]+
[Monitoring]![Sup call 3a]+
[Monitoring]![Sup call4a]+
[Monitoring]![Sup call 5a]+
[Monitoring]![Sup call1b]+
[Monitoring]![Sup call2b]+
[Monitoring]![Sup call 3b]+
[Monitoring]![Sup calll 4b]+
[Monitoring]![Sup call 5b]+
[Monitoring]![QC Call 1c]+
[Monitoring]![QC Call 2c]+
[Monitoring]![QC Call 3c]+
[Monitoring]![QC Call 4c]+
[Monitoring]![QC Call 5c]+
[Monitoring]![Trainer Call 1d]+
[Monitoring]![Trainer Call 2d]+
[Monitoring]![Trainer Call 3d]+
[Monitoring]![Trainer Call 4d]
)



 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

eerich
  • Locked
  • Question
IIF Help on complex query
Replies
5
Views
272
Andrzejek
Andrzejek
cimoli
  • Locked
  • Question
Access Query IIF statement with multiple conditions 3
Replies
6
Views
534
cimoli
cimoli
PWD
  • Locked
  • Question
Access 2019 IIF + Public Function 1
Replies
5
Views
138
PWD
PWD
jmc014
  • Locked
  • Question
IIf command with Between
Replies
1
Views
96
dhookom
dhookom
kopy
  • Locked
  • Question
Query Criteria Problem
Replies
3
Views
104
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top