joining queries in a report

[Guest]

I'm trying to join multiple simple queries in a report, but I get the
following error message: "You have chosen fields from record sources which
the wizard can't connect." The queries are filters that look for college
courses that meet certain graduation requirements (e.g. natural science,
social science, English/literature, etc.). The table listing all the courses
has a separate column for each of the grad requirement categories, so an
individual course record has an entry in one of those columns only if it
meets that requirement.

Have I set up the table or queries incorrectly? Surely the report function
can do this.

Thanks

 

[Marc]

I'm trying to join multiple simple queries in a report, but I get the
following error message: "You have chosen fields from record sources which
the wizard can't connect." The queries are filters that look for college
courses that meet certain graduation requirements (e.g. natural science,
social science, English/literature, etc.). The table listing all the
courses
has a separate column for each of the grad requirement categories, so an
individual course record has an entry in one of those columns only if it
meets that requirement.

Have I set up the table or queries incorrectly? Surely the report function
can do this.

Thanks

It depends. In your database, look at the database toolbar. In Access 2003,
near the right end is an icon with three squares that are linked. Click on
it. It will bring up the relationships window. If it is blank, click on the
square with yellow plus sign. Add all your tables. Once that is done, now
join the tables. For instance from the course table with courseId as the
primary key to the students courses table with courseId as the foreign key.
Once done the report wizard will be a lot happier. If you can't find keys
relating the tables together, you will probably have to rethink the database
design.
HTH
Marc

 

[Guest]

Thanks, Marc. That did the trick. Now all I gotta do is format the dang
report so it looks good.