DCOUNT Issue - MS Access 97
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'")