Excluding Wild Card Search

[Access_Help]

=Count(IIf([Grade]="A*")

How do I get this to only count A* grades and prevent it from performing like a wild card search.

I know this might be something simple, but just can't figure it out.

 

[Galaxiom]

Normally you would surround the * with square brackets
[*] to prevent it being the wildcard but it only works with the Like operator not equals.

That expression isn't going to work anyway.

Maybe you really just want a DCount rather than a query.

DCount("*", "tablename", "Grade='A*'")

Otherwise, what does the rest of your query look like and what will it be used for?