How do I only show yes values in a query which contains lots of y.

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

Guest

I have several yes fields but I only want to lists the ones which contains
values
 
"yes fields"?

I guess in the criteria you'd put...

= Yes


or

= -1



Rick B
 
I have several yes fields but I only want to lists the ones which contains
values
Click to expand...

Please explain what you mean.

There's no such thing as a "yes field" - there are Yes/No datatype
fields; and I am not certain what you mean by "want to list the ones
which contain values" - a Yes/No field ALWAYS contains a value which
may be Yes or it may be No.

John W. Vinson[MVP]
 
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

Not "Y"??? 1
Convert string value to numeric value 3
Combining queries that don't match 0
Filter Fields Containing Values Found in Another Table 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Need null values for several fields in db 1
using field name as value in query 2
Cross Tab Queries 4

Back
Top