What's wrong with this Access 97 formula
by learneverything
In reply to
What's wrong with this Ac ...
What's wrong with this Access 97 formula
by learneverything
In reply to
What's wrong with this Ac ...
What's wrong with this Access 97 formula
=DCount("[Survey Number]","Survey Results"," [Weekend Retreat] =B")
I tried putting another set of quotes around the B, thinking maybe it was due to the answer being alpha rather than numeric. I got an error message about an invalid syntax. This formula has worked for all the numeric controls in the form. This field will contain a "B" for best, or a "W" for worst. Any help would be appreciated. Feel free to e-mail me directly if you need more info. I have the feeling I'm missing something easy.
This conversation is currently closed to new comments.