p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   DCOUNT Issue - MS Access 97 (http://p2p.wrox.com/showthread.php?t=19709)

snoopy92211 October 11th, 2004 01:38 PM

DCOUNT Issue - MS Access 97
 
Greetings.

I am trying to figure out this DCOUNT Issue. I'm trying to (in a report) count the number of items in the item table where the completion field is NOT withdrawn

Here's my control source. It's not working. I'm thinking that I can't use the dcount function with a not equals to, but is there any other way i can do this?

=DCount("ItemID","IRSItem","COMPLETIONPERCENTAGE NOT 'W/D'")

HELP!!

thanks!


Ray Pinnegar October 12th, 2004 02:38 AM

Try:

=DCount("ItemID","IRSItem","COMPLETIONPERCENTAGE <> 'W/D'")

Cheers Ray


All times are GMT -4. The time now is 11:24 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.