General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
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.