DSUM Error

[NeoFax]

I am getting an error with the below DSUM expression:

LeadHours:
IIf([helo#]<41200,nz(DSum("HOURS","tblUnitHours","[STATION]='" &
[STATION] & "' [LongNose]='S'"),
0),nz(DSum("HOURS","tblUnitHours","[STATION]='" & [STATION] &
"' [LongNose]='L'"),0))

It has to do with the quotations around the S and L. Should they be
single or double quotes? Thanks!

Terry

 

[Dennis]

Your problem is in the 3rd section of the DSum statements. This is the
equivalent of a SQL where clause without the where. Should the [LongNose] be
combined with the [Station] as and AND or as an OR
e.g.
nz(DSum("HOURS","tblUnitHours","[STATION]='" & [STATION] &
"' And [LongNose]='L'"),0))
nz(DSum("HOURS","tblUnitHours","[STATION]='" & [STATION] &
"' OR [LongNose]='L'"),0))

 

[Klatuu]

This is the part I don't understand:

"[STATION]='" & [STATION] & "' [LongNose]='L'"),0))

If the value of the field STATION were Bingo, it would translate to:
Bingo[LongNose]=L

Sorry, but that doesn't make sense. What is it you are trying to do?

 

[NeoFax]

Your problem is in the 3rd section of the DSum statements. This is the
equivalent of a SQL where clause without the where. Should the [LongNose] be
combined with the [Station] as and AND or as an OR
e.g.
nz(DSum("HOURS","tblUnitHours","[STATION]='" & [STATION] &
 "' And [LongNose]='L'"),0))
nz(DSum("HOURS","tblUnitHours","[STATION]='" & [STATION] &
 "' OR [LongNose]='L'"),0))

I am getting an error with the below DSUM expression:

LeadHours:
IIf([helo#]<41200,nz(DSum("HOURS","tblUnitHours","[STATION]='" &
[STATION] & "' [LongNose]='S'"),
0),nz(DSum("HOURS","tblUnitHours","[STATION]='" & [STATION] &
"' [LongNose]='L'"),0))

It has to do with the quotations around the S and L.  Should they be
single or double quotes?  Thanks!

Terry- Hide quoted text -

- Show quoted text -

I fixed it. I was stupid and forgot to put the and after the single
quote like Dennis states. Need to pay more attention next time.