Search results for query: *

This Is just what I wanted thanks a lot, m8

It does not mater which qty field, the first occurance is good enough

No this is not what I wanted but thanks for the effort. I want something like: SELECT Item, Qty FROM MyTable WHERE Item = (SELECT DISTINCT Item FROM MyTable) but this does not work

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...

Hey lxn. I have posted this question in a couple of usenet newsgroups. So far I got two responses and both of them suggested the "replication" thing. For your convenience I will post their peplies below: ===== comp.databases.ms-access Although I've never used it, I believe...

Yep! It sounds like the same situation. I think I will do some research on this "replication" thing. Maybe its some kind of a shortcut that the clever people use ;-)

Replication? Do you mean the two databases will cause some kind of an error (called “replication” / caused by “replication”) or do you call what I’m trying to do “replication”? Sorry for my stupidity as far as DB’s are concerned! What would you suggest? * The factory is about 100 kilometres...

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...