[RESOLVED] syntax error missing in query expression

[SamOscarBrown]

So,....that begs the question, Why?
If your ExpCost is a Currency field, you don't need to try that....
If, when you RETURN a value from the Currency field (ExpCost), you can prepend a dollar sign ($) in whatever control you display it..if you desire.