A
alee via AccessMonster.com
Hello,
I have a table similar to this:
CustID Location OrderID
1 Vancouver 12
2 Vancouver 13
3 Boston 14
4 Boston 15
5 New York 16
6 New York 17
How can I use Access SQL query to generate
CustID Location OrderID
1 Vancouver 12
3 Boston 14
5 New York 16
Any help will be greatly appreciated.
Alan L.
I have a table similar to this:
CustID Location OrderID
1 Vancouver 12
2 Vancouver 13
3 Boston 14
4 Boston 15
5 New York 16
6 New York 17
How can I use Access SQL query to generate
CustID Location OrderID
1 Vancouver 12
3 Boston 14
5 New York 16
Any help will be greatly appreciated.
Alan L.