Access 2007 Report shows multiple rows, query shows single row

  • Thread starter Tony No Baloney
  • Start date
T

Tony No Baloney

I am using Access 2007 for my database.

When I run the query, the output on the screen looks right. For
example:

First Last Company Group
Jane Doe ABC, inc. Managers

When I run the report, which points to this query, I get:

First Last Company Group
Jane Doe ABC, inc. Managers
DEF co Sr. Managers
Widgets, inc. Cafeteria staff

The ABC, inc. is highlighted in blue. I don't know why it is showing
the data from the other companies.

The table that I am pulling from is pulling the company names as a
SELECT clause from another table.

When I go in the design view from the report, the "Company" and
"Group" have their textboxes in white,
and the "first" and "last" are clear (they are the ones showing up
correctly).

Please advise (step by step instructions would be great).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top