In crosstab query results,the value of a checked Yes/No data type field will display as ____.
A)0
B)1
C)-1
D)+1

Name: In crosstab query results,the value of a checked Yes/No data type field will display as ____. A)0 B)1 C)-1 D)+1
Brand: Quizplus
Rating: 4.7 (33 reviews)

Question

Quizplus · Accepted Answer

In a crosstab query, the value of a checked Yes/No data type field will display as -1. This is because in Microsoft Access, a checked checkbox or Yes value in a Yes/No field is stored as -1, while an unchecked checkbox or No value is stored as 0.

In Crosstab Query Results,the Value of a Checked Yes/No Data