General discussion

Locked

What's wrong with this Access 97 formula

By learneverything ·
The following formula is giving me this weird symbol that looks kind of like a 3 character word, "TO*" (the * represents a character that looks like Gamma in the greek alphabet)

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

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

What's wrong with this Access 97 formula

by Larry H. In reply to What's wrong with this Ac ...

Add single quotes around the B like this:
=DCount("[Survey Number]","Survey Results"," [Weekend Retreat] = 'B' ")

Collapse -

What's wrong with this Access 97 formula

by learneverything In reply to What's wrong with this Ac ...

Well Duh! Thanks. I'm glad I was close anyway.

Collapse -

What's wrong with this Access 97 formula

by KW In reply to What's wrong with this Ac ...

Correct:

=DCount("[Survey Number]","[Survey Results]",[Weekend Retreat]=' & "B" & "'")

Collapse -

What's wrong with this Access 97 formula

by learneverything In reply to What's wrong with this Ac ...
Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums