Missing Operator

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I'm getting a Missing Operator message on this statement.
Any Input is appreciated.
Thanks
DS

CARDS = Nz(DCount("PayAppliedID", "tblPayApplied", "(PayAppliedCCRef Is Not
Null) And PayAppliedCheckID = " & frm!TxtCheckID.value & " And
PayAppliedRefundID = 0"), 0)
 
What are the data types of PayAppliedCheckID and PayAppliedRefundID. If
either are text, you need quotes around the values.
 
I'm getting a Missing Operator message on this statement.
Any Input is appreciated.
Thanks
DS

CARDS = Nz(DCount("PayAppliedID", "tblPayApplied", "(PayAppliedCCRef Is Not
Null) And PayAppliedCheckID = " & frm!TxtCheckID.value & " And
PayAppliedRefundID = 0"), 0)
Click to expand...

If txtCheckID is NULL you will get this error message. You may need to check
for that situation before this line, or use the NZ() function to return a
value.
 
Thanks John. You right the CheckID was null, the value wasn't being passed.
I corrected that and it works now.
Thank you.
DS
 
Back
Top