Many data instead of only one.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George - 18 Jun 2004 15:35 GMT

Hi, here is an exemple.
I have a table with 3 column:
1- Manufacturer 2-Product 3-Representant

A manufacturer associate with a product may have many
representants.
I could make a row for each of the representant but there
is a problem when i search info. It is that if I search
the products and representents of a manufacturer, instead
of having a row that shows the manufacturer-product-list
of Representent, it will give me as many row that there is
representant.
Note: The reprensentant is not reprensenting all the
company product.

Thanks

Reply to this Message

Steve Schapel - 18 Jun 2004 23:03 GMT

George,

With this data structure, a Select query will do exactly as you have
described, i.e. it will return all records from the table which match
your criteria.

There are ways to concatenate, in a query, the values in multiple
records with a common value in another field. An example can be found
at http://www.mvps.org/access/modules/mdl0004.htm and another at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Funct
ion%20To%20Concatenate%20Child%20Records'

Another approach which may serve your purpose, is to simply make a
report based on your existing query, and set the Hide Duplicates
property to Yes for the Manufacturer and Product textboxes.

Signature

Steve Schapel, Microsoft Access MVP

> Hi, here is an exemple.
> I have a table with 3 column:
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message