Excluding Wild Card Search (1 Viewer)

=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.

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.

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