hi i have query which has field EXCHID,CELL,BAND,BLSTATE
I want count of cells in following situations
1. count if band=900 and blstate= is not MBL for specified EXCHID and CELL
2. Count if band=900 and blstate = MBL for specified EXCHID and CELL
3. count if band=1800 and blstate= is not MBL for specified EXCHID and CELL
4. Count if band=1800 and blstate = MBL for specified EXCHID and CELL
Give me a way of doing this like in report format .When i write SQL for this , access choked
SELECT Query1.EXCHID, Query1.CELL, Query1.BLSTATE, Query1.[BAND], Count(Query1.CELL) AS CountOfCELL
FROM Query1
GROUP BY Query1.EXCHID, Query1.CELL, Query1.BLSTATE, Query1.[BAND]
HAVING (((Query1.BLSTATE)="MBL") AND ((Query1.[BAND])="GSM900"));
please help i need it very urgently