Hi,
I am new to access. I seek some help creating a query.
I have a table with field Date, Time, Traffic, cell, ...
I wish to create a query, which gives me one record from this table where Traffic is max, for that cell along with all other fields related to that record.
Date Time Cell Name Traffic TR PR CR DR RK
06-Mar-19 12:00:00 AM XX001A 11.9542 1 12 0 12 2
06-Mar-19 12:00:00 AM XX001B 11.7528 2 11 0 11 2
06-Mar-19 12:00:00 AM XX001C 11 2 11 0 11 2
07-Mar-19 12:00:00 AM XX001A 14 1 12 0 12 2
07-Mar-19 12:00:00 AM XX001B 11.0222 1 13 0 13 2
07-Mar-19 12:00:00 AM XX001C 11 3 11 0 11 2
08-Mar-19 12:00:00 AM XX001A 10.8222 2 11 0 11 2
08-Mar-19 12:00:00 AM XX001B 11 2 11 0 11 2
08-Mar-19 12:00:00 AM XX001C 10.6847 2 12 0 12 2
09-Mar-19 12:00:00 AM XX001A 12 1 12 0 12 2
09-Mar-19 12:00:00 AM XX001B 10.9944 3 11 0 11 2
09-Mar-19 12:00:00 AM XX001C 12.3639 1 12 0 12 2
10-Mar-19 12:00:00 AM XX001A 9.3329 3 10 0 10 2
10-Mar-19 12:00:00 AM XX001B 10.9819 2 11 0 11 2
Appreciate your help.
Thx,
I am new to access. I seek some help creating a query.
I have a table with field Date, Time, Traffic, cell, ...
I wish to create a query, which gives me one record from this table where Traffic is max, for that cell along with all other fields related to that record.
Date Time Cell Name Traffic TR PR CR DR RK
06-Mar-19 12:00:00 AM XX001A 11.9542 1 12 0 12 2
06-Mar-19 12:00:00 AM XX001B 11.7528 2 11 0 11 2
06-Mar-19 12:00:00 AM XX001C 11 2 11 0 11 2
07-Mar-19 12:00:00 AM XX001A 14 1 12 0 12 2
07-Mar-19 12:00:00 AM XX001B 11.0222 1 13 0 13 2
07-Mar-19 12:00:00 AM XX001C 11 3 11 0 11 2
08-Mar-19 12:00:00 AM XX001A 10.8222 2 11 0 11 2
08-Mar-19 12:00:00 AM XX001B 11 2 11 0 11 2
08-Mar-19 12:00:00 AM XX001C 10.6847 2 12 0 12 2
09-Mar-19 12:00:00 AM XX001A 12 1 12 0 12 2
09-Mar-19 12:00:00 AM XX001B 10.9944 3 11 0 11 2
09-Mar-19 12:00:00 AM XX001C 12.3639 1 12 0 12 2
10-Mar-19 12:00:00 AM XX001A 9.3329 3 10 0 10 2
10-Mar-19 12:00:00 AM XX001B 10.9819 2 11 0 11 2
Appreciate your help.
Thx,