Yes/no criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a mailing list with town, street and postcode fields and a checkbox. How do I print a list of addresses which have had the checkbox ticked and ignore the rest?
 
Clare-

Create a query on your table. Include the "checkbox" field and enter TRUE
on the criteria line under that field. Use the query to create your report.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
Clare said:
I have a mailing list with town, street and postcode fields and a
Click to expand...
checkbox. How do I print a list of addresses which have had the checkbox
ticked and ignore the rest?
 
thanks for that, I was trying is true or is 1 and it didn't like it. i think i was trying to make it harder than it actually was
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending null data and moving! 4
Splitting a large field up into six new fields 3
Split data in field on character return 0
Filter query with checkboxes 0
Sorting address fields 4
How to sort a list with Mr, Mrs, Miss ? 5
Finding and deleting dupe queries across two fields 6
Checkboxes and Query Criteria 1

Back
Top