Sort with multiple fields

[JeffH]

I need to create a sort from multiple fields. I have 4
fields that are Y/N. If all four are yes then I I don't
want it to show up. If any of the four are no. I want
the record to show up. I'm trying to set this up in the
design section of the query. Currently if I a yes in any
of the field the record doesn't show up.



Thanks alot Guys/Gails!!!!

 

[Steve Schapel]

Jeff,

Try this...
In the Field row of a blank column in the query design grid, put a
calculated field like this...
ShowTest: [1stYN]*[2ndYN]*[3rdYN]*[4thYN]
(replace with your actual field names, of course)
.... and then, in the criteria of this column, put 0

 

[Michel Walsh]

Hi,


With Jet? The SQL view should got something like:


... WHERE NOT( f1 AND f2 AND f3 AND f4 )



Hoping it may help,
Vanderghast, Access MVP

 

[JeffH]

Thanks...
Works great!!

-----Original Message-----
Jeff,

Try this...
In the Field row of a blank column in the query design grid, put a
calculated field like this...
ShowTest: [1stYN]*[2ndYN]*[3rdYN]*[4thYN]
(replace with your actual field names, of course)
.... and then, in the criteria of this column, put 0

--
Steve Schapel, Microsoft Access MVP

I need to create a sort from multiple fields. I have 4
fields that are Y/N. If all four are yes then I I don't
want it to show up. If any of the four are no. I want
the record to show up. I'm trying to set this up in the
design section of the query. Currently if I a yes in any
of the field the record doesn't show up.



Thanks alot Guys/Gails!!!!

.