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
 
Back
Top