radstad
asked on
Difficult SQL QUERY
Experts:
I have to make a query for table in Access , like this:
City Orders
-------------------------- ---
A 200
B 500
A 1200
A 700
B 900
C 400
..
..
Using one or two query to reach result like this:
City Orders<=500 Orders>500
-------------------------- ---------- ------
A 1 2
B 1 1
C 1
Please answer as soon as possible.
thanks
I have to make a query for table in Access , like this:
City Orders
--------------------------
A 200
B 500
A 1200
A 700
B 900
C 400
..
..
Using one or two query to reach result like this:
City Orders<=500 Orders>500
--------------------------
A 1 2
B 1 1
C 1
Please answer as soon as possible.
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
But I see that you registered with EE just today! Have you searched it in MS Access Section.