Pulling Back Data

[Guest]

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?

 

[Guest]

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.