Problem with Query, Relationships and Reports in Access 97

I know.. I know... I am way behind the curve on versions of Access, however,
my state government is holding me back. I am trying to create a simple
report using data from two different tables with a simple one-to-many
relationship. The first table is Manufacturers Name and address. The second
table is the manufacturers product list. The join is on the manufacturer's
name. For some reason when I create my report, which is a simple letter with
name address and list of their products, I get all the products in the
database in the report. I have tried changing the join types, with no luck.
I am getting the right sub-totals by manufacturer, but the next manufacturer
continues on the same page. I know that I am missing something simple.

Rob

Try a report to show the manufacturers and a subreport for the products. Link
them by manufacturer's name and it should work.
--
Milton Purdy
ACCESS
State of Arkansas


"FMO902" wrote:

I know.. I know... I am way behind the curve on versions of Access, however,
my state government is holding me back. I am trying to create a simple
report using data from two different tables with a simple one-to-many
relationship. The first table is Manufacturers Name and address. The second
table is the manufacturers product list. The join is on the manufacturer's
name. For some reason when I create my report, which is a simple letter with
name address and list of their products, I get all the products in the
database in the report. I have tried changing the join types, with no luck.
I am getting the right sub-totals by manufacturer, but the next manufacturer
continues on the same page. I know that I am missing something simple.

Rob

On Thu, 10 Sep 2009 12:11:40 -0700, FMO902
wrote:

I know.. I know... I am way behind the curve on versions of Access, however,
my state government is holding me back. I am trying to create a simple
report using data from two different tables with a simple one-to-many
relationship. The first table is Manufacturers Name and address. The second
table is the manufacturers product list. The join is on the manufacturer's
name. For some reason when I create my report, which is a simple letter with
name address and list of their products, I get all the products in the
database in the report. I have tried changing the join types, with no luck.
I am getting the right sub-totals by manufacturer, but the next manufacturer
continues on the same page. I know that I am missing something simple.

Rob

Please open your Query in SQL view and post the SQL text here. There's
evidently something wrong with the join, but we can't tell what based on your
post.
--

John W. Vinson [MVP]