Designing query to select entries with 6 of 9 columns greater than 3

04-03-2009, 11:15 AM

mrc881

Novice

Join Date: Apr 2009

Posts: 1

Designing query to select entries with 6 of 9 columns greater than 3

Hello,

I am trying to design a query to pull out records from my database where 6 or more of the 9 columns in the record are greater than a certain value. Each row has 9 numbers in it (+ the key).

Any idea how to do this other than writing OR searches for every single possibility? (There are many possibilities.)

Thanks!

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show/Unshow Columns in Query	simmurray	Queries	0	03-28-2009 08:03 AM
Select query with two criteria	corni	Queries	1	01-22-2009 02:23 AM
very difficult (for me!) SELECT query	igorbaldacci	Queries	1	12-02-2008 12:30 PM
Add Columns to query	4petessake	Access	0	06-15-2007 11:38 AM
Using SELECT query within a VBA code in Access	championss	Programming	4	10-23-2006 03:50 PM

All times are GMT -8. The time now is 08:13 PM.