G
Guest
Howdy from Oklahoma!!
I am new to ACCESS and needing help with a Query.
I am having a problem with a query that is performing an addition function
of 4 other fields. As in Sum1: Q1 + Q2 + Q3 + Q4. (where each Q# is an
alias for a different QTY value from the table.)
It works fine except when one of the Q's does not have a value and then the
Sum1 is blank.
I have tried using an IIF statement as in Q2: IIf([QTY2] = Null,0,[QTY2])
in the query to identify each alias Q# to make sure the fact that if the QTY#
value is null that a "0" is the value for the Q# field. but still the Sum1 is
blank when the query is ran.
Any ideas would be greatly appreciated. AND AS ALWAYS, THANKS IN ADVANCE!!!!
I am new to ACCESS and needing help with a Query.
I am having a problem with a query that is performing an addition function
of 4 other fields. As in Sum1: Q1 + Q2 + Q3 + Q4. (where each Q# is an
alias for a different QTY value from the table.)
It works fine except when one of the Q's does not have a value and then the
Sum1 is blank.
I have tried using an IIF statement as in Q2: IIf([QTY2] = Null,0,[QTY2])
in the query to identify each alias Q# to make sure the fact that if the QTY#
value is null that a "0" is the value for the Q# field. but still the Sum1 is
blank when the query is ran.
Any ideas would be greatly appreciated. AND AS ALWAYS, THANKS IN ADVANCE!!!!