T TOYAPFYA Mar 4, 2009 #1 When using a Yes/No field, how would you set the criteria so that a query or report would only pull all "Yes" or all "No" entries?
When using a Yes/No field, how would you set the criteria so that a query or report would only pull all "Yes" or all "No" entries?
F fredg Mar 4, 2009 #2 When using a Yes/No field, how would you set the criteria so that a query or report would only pull all "Yes" or all "No" entries? Click to expand... To show Yes records, as criteria on the Yes/No column, write: -1 To show No records, as criteria write: 0
When using a Yes/No field, how would you set the criteria so that a query or report would only pull all "Yes" or all "No" entries? Click to expand... To show Yes records, as criteria on the Yes/No column, write: -1 To show No records, as criteria write: 0
J John W. Vinson Mar 4, 2009 #3 When using a Yes/No field, how would you set the criteria so that a query or report would only pull all "Yes" or all "No" entries? Click to expand... True or -1 for yes entries False or 0 for no entries
When using a Yes/No field, how would you set the criteria so that a query or report would only pull all "Yes" or all "No" entries? Click to expand... True or -1 for yes entries False or 0 for no entries
