Its been asked before but no complete resolutions for that eask it seems.
The offered solution was Select COUNT (Yes/Nofield) from tablename WHERE YesNo=1
I have a very basic Yes/No field for attending an event. (Attending)
The formula I am using passes the Verify test. But when I preview it it says "This DataPage uses parameters. To simulate this DataPage with parameters, enter values below." Entering a value or leaving empty it concludes with "Error in Formula"
Using this formula:
SELECT Count([@Attending]) FROM tbl_mytablename WHERE [@field:Attending]="1"
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
roattw
Its been asked before but no complete resolutions for that eask it seems.
The offered solution was Select COUNT (Yes/Nofield) from tablename WHERE YesNo=1
I have a very basic Yes/No field for attending an event. (Attending)
The formula I am using passes the Verify test. But when I preview it it says "This DataPage uses parameters. To simulate this DataPage with parameters, enter values below." Entering a value or leaving empty it concludes with "Error in Formula"
Using this formula:
SELECT Count([@Attending]) FROM tbl_mytablename WHERE [@field:Attending]="1"
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.