DAvg Not Working

[BLFOSTER]

I have 2 text boxes in a form header to display average wage. Exact same expression with slightly different criteria. One works, the other doesn't:



DAvg([Wage],"MyTable",[MyField]="PCC") this one works

DAvg([Wage],"MyTable",[MyField]="DHS") this one DOES NOT WORK - no #error# or anything....just NOTHING.

Any Ideas?

Thank you!

[RuralGuy]

All of the Domain Functions use only STRINGS for all of the arguments. http://access.mvps.org/access/general/gen0018.htm

[BLFOSTER]

Perfect! Thanks!

[RuralGuy]

You're welcome. Glad we could help.