Access Query question.

[P4ss]

Hello There.
I have a problem getting results I need out of a query I run in access.I have this sample of a wireless access database that I am posting bellow with my question:
ID AP location room Channel S/N(dBm)
16 ng LB2S 2134a 1 16
17 dl LB2N 2134a 11 2
18 ng LB3S 2134a 6 13

19 ng LB2S 2135a 1 25
20 dl LB2N 2135a 11 5
21 li LB3S 2135a 6 15
22 2135a 11 0

23 NG LB2S 2136a 1 9
24 NG 2136a 6 1
25 DL LB2N 2136a 11 2
26 LB3S 2136a 6 7
As you can see I have 3 rooms with multiple AP signals and their Signal to Noise ratio.
Now consider that into the specific original "table" exist more than 200 rooms.
I want to run a query so it will provide me a list with those rooms that receive S/N ratio less than 10dbm.To be more accurate I need only the rooms wich their S/N ratio entries are bellow that limit of 10dbm.
That is lets say for the room 2134a when I run the query to be excluded because it has few entries above the 10 dbm range.
Thank you for your help.

 

[PHV]

A starting point:
SELECT room FROM yourTable GROUP BY room HAVING MAX([S/N(dBm)])<10

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[P4ss]

Do you mean that the ([S/N(dBm)])<10 should be under the room criteria to run the query?

 

[PHV]

What I posted is SQL code.
When in the query window choose the SQL view pane to write the SELECT instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886