Hi.
I'm taking a access class, Any help is appreciated!
The Question is, How many two bedroom apartments are in each location.
This query displays 6 rows showing each 2 bdrms, but I want to just have the location number in collum one, and how many 2 bed room apts are in each.
Code:SELECT LocationNum, Bdrms FROM CondoUnit WHERE Bdrms=2;