Dcount Syntak ?

N

NNlogistics

I am trying to use an "AND" with an "not isnull" in the criterea section of
dcount and I am having a problem. I think its a syntak error.

=DCount("[Combined]","qryPartHistory","[Combined] Like[Combo115] &
[fldSerialNumberIn] AND not isnull [fldDateShipped]")
It works until I add everything past AND.
 
D

Dirk Goldgar

NNlogistics said:
I am trying to use an "AND" with an "not isnull" in the criterea
section of dcount and I am having a problem. I think its a syntak
error.

=DCount("[Combined]","qryPartHistory","[Combined] Like[Combo115] &
[fldSerialNumberIn] AND not isnull [fldDateShipped]")
It works until I add everything past AND.
Click to expand...

If it all works until you add the AND, try this:

=DCount("[Combined]","qryPartHistory","[Combined] Like [Combo115] &
[fldSerialNumberIn] AND [fldDateShipped] Is Not Null")

BTW, that's "syntax", not "syntak".
 
N

NNlogistics

Thanks, that worked fine. Access is so Consistent
--
Thanks for any assistance


Dirk Goldgar said:
NNlogistics said:
I am trying to use an "AND" with an "not isnull" in the criterea
section of dcount and I am having a problem. I think its a syntak
error.

=DCount("[Combined]","qryPartHistory","[Combined] Like[Combo115] &
[fldSerialNumberIn] AND not isnull [fldDateShipped]")
It works until I add everything past AND.
Click to expand...

If it all works until you add the AND, try this:

=DCount("[Combined]","qryPartHistory","[Combined] Like [Combo115] &
[fldSerialNumberIn] AND [fldDateShipped] Is Not Null")

BTW, that's "syntax", not "syntak".

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Top