Assigning a value to a YES/No

[Guest]

I would like to make a query that would assign a value to yes or no. I am
working on a database for church. I basically have to keep up with the
points for awana. So I would like to either check yes or no to a field and
have access assign a point value. Then I could add up the columns and make a
report based on the points for the individual leaders. What criteria
statement would I use to complete this task.

Carolyn

 

[Duane Hookom]

You need to provide your table structure. Your mention of "add up the
columns" suggests your table(s) are un-normalized. If you intend to sum
values, you should be summing a single field across multiple records.

 

[David F Cox]

a yes/no field actually has a value. Access stores the data as -1 for yes
and 0 for no. In the query grid you can put:

points: -sum([myYN])