Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Yes/No checkboxes in queries

Status
Not open for further replies.
suzyg

suzyg

Technical User
Oct 23, 2007
9
0
0
CA
I've just set up a database in access 2000 and need to do a query on whether a payment has been made. The table field is a yes/no checkbox. Does anyone know how to set the criteria ( I'm not very good at SQL) so that only the unpaid bills are listed?? Please?!
 
Sort by date Sort by votes
In your criteria, enter any one of the following
Code: 
Yes
True
-1
 
Upvote 0 Downvote
If your field is called PAYMENT_PAID in the criteria you should say: NOT PAYMENT_PAID.
 
Upvote 0 Downvote
.....Or, if the checked box indicates a payment has been made and you're looking for unpaid accounts:
Code: 
No
False
0
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
181
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
213
TheresAlwaysAWay
TheresAlwaysAWay
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
78
Andrzejek
Andrzejek
datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
146
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
174
combo
combo

Part and Inventory Search

Sponsor

Back
Top