Problem with Query, Relationships and Reports in Access 97

  • Thread starter Thread starter FMO902
  • Start date Start date
F

FMO902

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.
 
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
Click to expand...

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.
 
Back
Top