• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 338
  • Last Modified:

Need Query Syntax Help

I have a query with a field named "TotJobHours".  This field is a calculation field made up by...
TotJobHours: [TotSomeHours]+[TotSomeMoreHours]+[TotEvenMoreHours]

But I need another query with a field that is something like...
RemainingJobHours: [TotSomeHours] where SomeHoursComplete = False +[TotSomeMoreHours] where SomeMoreHoursComplete = False + [TotEvenMoreHours] where EvenMoreHoursComplete = False
but this syntax is not correct.  Can someone provide guidance here?

--Steve
0
SteveL13
Asked:
SteveL13
  • 2
1 Solution
 
cyberkiwiCommented:
(all on one line)

RemainingJobHours:
IF(SomeHoursComplete, 0, [TotSomeHours])
+IF(SomeMoreHoursComplete, 0, [TotSomeMoreHours])
+IF(EvenMoreHoursComplete, 0, [TotEvenMoreHours])
0
 
cyberkiwiCommented:
I meant this: (all on one line)

RemainingJobHours:
IIF(SomeHoursComplete, 0, [TotSomeHours])
+IIF(SomeMoreHoursComplete, 0, [TotSomeMoreHours])
+IIF(EvenMoreHoursComplete, 0, [TotEvenMoreHours])
0
 
SteveL13Author Commented:
Thank you!
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now