Access Query

[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.

 

[SkipVought]

Hi,

I need only the rooms wich their S/N ratio entries are bellow that limit of 10dbm.

select room from YourTable
group by room
having Max([S/N(dBm)])<10

Skip,
[sub]
[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE! [/sub]

 

[Smeglor]

First rename the S/N(dBm) field to something else like SN

SELECT Table1.id, Table1.ap, Table1.location, Table1.room, Table1.channel, Table1.SN
FROM Table1
WHERE (((Table1.SN)<="10"));

I don't know sir...I guess its broke.

 

[P4ss]

LOL
Excuse me Sir, but can you brake it into pieces?
Lets start with the ABC first.
Where am I Supposed to type the code?

 

[xlbo]

Have you used Access queries before ??