View Single Post
  #1 (permalink)  
Old October 11th, 2004, 01:38 PM
snoopy92211 snoopy92211 is offline
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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!

Reply With Quote