I have on table with the following data:
Item Qty
Pencil 12
Eraser 3
Pencil 5
Pencil 4
Pen 3
Paint 3
Pen 3
I want to list out both Item and Qty but only the rows where the Item is not duplicated. The desired result will be:
Pencil 12
Eraser 3
Pen 3
Paint 3
Hi
Here is the scenario:
* Our client has a file-server with an Access DB
* We have a Win NT web-server with the same Access DB
* Our client’s DB is constantly being updated with the latest stock etc. from their factory.
* Our DB gets updated by our client’s reps. They are updating our DB...
Hi
Here is the scenario:
* Our client has a file-server with an Access DB
* We have a Win NT web-server with the same Access DB
* Our client’s DB is constantly being updated with the latest stock etc. from their factory.
* Our DB gets updated by our client’s reps. They are updating our DB...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.