Pulling Back Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Novice2000 - 14 Aug 2006 17:08 GMT

Hi,

This is probably really obvious, but not to me.

I have been sent a text file that has two columns. I created a table using
this information. One column has a company number and the second has a
product number. The problem is that there can be several products for one
company and each is attached to the company number. Like so:

Co. Product
19 2200
19 1400
19 3001
29 2200
29 3333
29 1400

How can I create a report that pulls back all three product number when the
company number is entered since there can be multiple lines for each company?

Reply to this Message

Wayne-I-M - 14 Aug 2006 19:25 GMT

Open your report (design view)

Bring in both fields [Co] and [Product]

Click the grouping and sorting icon and own the dropdown select Co.
At the bottom of this box this is a section for header and footer. Make
sure you have a group Header for your Co field.

Close this box.

In your report design drag the [Co] field into the group header area and
then view the report. Each Co will have it corresponding Products listed
beneath it (or next to it depending on your design.

Signature

Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.

> Hi,
>
[quoted text clipped - 15 lines]
> How can I create a report that pulls back all three product number when the
> company number is entered since there can be multiple lines for each company?

Reply to this Message