DCount problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Βάππας Κωνσταντίνος (_at_discussions.microsoft.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 02:27:01 -0800

I use DCount function:

DCount("[InsurerID]";"ApplicationForm";'[ApplicationFormNumber]=[InsertApplicationFormNumber] & "001" ')

it will return 1 record, that's true.
But if i use

DCount("[InsurerID]";"ApplicationForm";'[ApplicationFormNumber]=[InsertApplicationFormNumber] & "*" ')

or

DCount("[InsurerID]";"ApplicationForm";'[ApplicationFormNumber]=[InsertApplicationFormNumber] & "???" ')

it will return 0. It should return 1 record again!