G
Guest
Hi
I have a table that shows material numbers, vendor numbers, e-mails ect.
Some of the material numbers are shown twice in the the table. This is
because a vendor can have 2 e-mail adr. For different reasons I need a query
to always return the first record it finds for each unique material number,
so I get a list of materials with only one vendor, one e-mail and so on. How
can this be done?
regards
Ticotion
I have a table that shows material numbers, vendor numbers, e-mails ect.
Some of the material numbers are shown twice in the the table. This is
because a vendor can have 2 e-mail adr. For different reasons I need a query
to always return the first record it finds for each unique material number,
so I get a list of materials with only one vendor, one e-mail and so on. How
can this be done?
regards
Ticotion