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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Criteria for Yes/No field 1

Status
Not open for further replies.
ncopeland

ncopeland

IS-IT--Management
Mar 12, 2002
88
GB
Hi

I have a field that is a Yes/No field. Within a report I have set the criteria as follows.

-1 or Is Null

as I want it to display all records that have not got a tick in the box.

It doesn't seem to work any suggestions.

Running Access 2003.

KR

NC.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
496
dhookom
dhookom
ptrifile
  • Locked
  • Question
Sum with multiple criteria
Replies
2
Views
299
dhookom
dhookom
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
356
sxschech
sxschech
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
195
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Report Header and Column Formatting Issue 1
Replies
2
Views
631
BallunarCrew
BallunarCrew

Part and Inventory Search

Sponsor

Back
Top