filter checkbox from form on report

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

Guest

My inventory form has a SOLD checkbox and I don't want it to print those Sold entries on my Inventory report. But I don't want to delete that entry. Please help. Thanks
 
Jodi,

I would assume your report is based on a query and that
the checkbox is stored in a table somewhere.
Add the checkbox field to your report's query and set the
criteria in the query to false (or zero). This will
eliminate all sold items from your report.

If I have this all wrong pls post back with some more
details on your db.

HTH,

Terry
-----Original Message-----
My inventory form has a SOLD checkbox and I don't want it
Click to expand...
to print those Sold entries on my Inventory report. But I
don't want to delete that entry. Please help. Thanks
 
You must log in or register to reply here.

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

how do I not show a record in a report when the total is zero? 1
Inventory on hand 1
Date based query problem 4
Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1
Checkbox magic needed... (remove...) 2
Missing Report Header 1
How do I filter an Access report? 4
First In First Out 1

Back
Top