|
Subject:
|
DCOUNT Issue - MS Access 97
|
|
Posted By:
|
snoopy92211
|
Post Date:
|
10/11/2004 1:38:29 PM
|
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 By:
|
Ray Pinnegar
|
Reply Date:
|
10/12/2004 2:38:09 AM
|
Try:
=DCount("ItemID","IRSItem","COMPLETIONPERCENTAGE <> 'W/D'")
Cheers Ray
|
|
