Sort with multiple fields

  • Thread starter Thread starter JeffH
  • Start date Start date
J

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!!!!
 
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
 
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
 
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!!!!
Click to expand...
.
Click to expand...
 
Back
Top