Dcount Syntak ?

[Guest]

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.

 

[Dirk Goldgar]

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.

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".

 

[Guest]

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

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.

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)