Select data once in a query even if there is more of the same kind

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table containing following fields:
Brand name, Manufactor, Contact name, contact mail, and Phone
The Brand name is unique. But the manufactor might have several brand names.
I want to create a query that shows a list of the manufactors, but they must
only be shown once.
Can anybody help me with this, please.
Thanks in advance
 
Poul,

Start making a new query in design view, add no table, then revert to
SQL view and paste the following expression:

SELECT DISTINCT Manufactor FROM MyTable

replacing MyTable with the actual table name. This should do the job.

HTH,
Nikos
 
One approach would be to create a separate table for Manufacturers. You
could then assign a ManufacturersID number to each manufacturer and replace
the Manufactor field in your table with the a ManufacturersID field with
corresponding ManufacturersID for each Brand Name.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


message I have a table containing following fields:
Brand name, Manufactor, Contact name, contact mail, and Phone
The Brand name is unique. But the manufactor might have several brand
names.
I want to create a query that shows a list of the manufactors, but they must
only be shown once.
Can anybody help me with this, please.
Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a Case-Sensitive Group By Totals Query - Is there a Workaroun 4
Query to select individual records 4
Checking if data exists another table and, if yes, extracting a value 0
Selecting the same field more than once 2
How do you make a Query that shows records even if a field is blan 5
one combobox, one query, 2 combined fields 2
Using a field name as variable in a query 1
Total appointments per agent 2

Back
Top