<div>
(all on one line)<br />
<br />
RemainingJobHours:<br />
IF(SomeHoursComplete, 0, [TotSomeHours])<br />
+IF(SomeMoreHoursComplete,<wbr /> 0, [TotSomeMoreHours])<br />
+IF(EvenMoreHoursComplete,<wbr /> 0, [TotEvenMoreHours])
</div>


(all on one line)

RemainingJobHours:
IF(SomeHoursComplete, 0, [TotSomeHours])
+IF(SomeMoreHoursComplete, 0, [TotSomeMoreHours])
+IF(EvenMoreHoursComplete, 0, [TotEvenMoreHours])

<div>
<div class="content wysiwyg-content">
I have a query with a field named &quot;TotJobHours&quot;. &nbsp;This field is a calculation field made up by...<br />
TotJobHours: [TotSomeHours]+[TotSomeMor<wbr />eHours]+[T<wbr />otEvenMore<wbr />Hours]<br />
<br />
But I need another query with a field that is something like...<br />
RemainingJobHours: [TotSomeHours] where SomeHoursComplete = False +[TotSomeMoreHours] where SomeMoreHoursComplete = False + [TotEvenMoreHours] where EvenMoreHoursComplete = False<br />
but this syntax is not correct. &nbsp;Can someone provide guidance here?<br />
<br />
--Steve
</div>
</div>


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

Need Query Syntax Help

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.