Query criteria and checkboxes

  • Thread starter Michael Bentfeld
  • Start date
M

Michael Bentfeld

I have a database (actually 2 databases together) that
generates reports. The reports are supposed to show only
supposed to show records that were entered on the current
date, or records from previous days where a checkbox field
in that record has not been checked. I set up the
criteria for the fields as follows (listed here as "Field
name": "Criteria:

DATE: Date()
SHIPPED: 0
RECEIVED: 0

When the report is run, the report shows not only today's
records, but also records from prior days, even when
records from prior days have been checked off. Did I set
up the criteria wrong? Please help.
 

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

Top