Trying to quary two tables

[Michael H. Cox]

Hey guys,

I am not a big database guy. I had a client call me a few days ago,
however, and asked if I could update a form for him in a MS Access database,
along with some general computer problems. That was something I could do for
him, so I agreed. When I got there, he also wanted me to do some more
extensive changes to MS Access. I'm sure all these things are simple, but I
just don't know how to do them.

The person who created the database (who, of course, is no longer around),
created this database for an employee referral company. The database has a
couple of tables. The first one contains all the applicants (the ones
looking for jobs). Another one contains all the employers. In the database,
they record by ID who the applicant is hired for, etc,etc.

They have a report that they print for the applicant to sign before they
start working for a new company. Their switchboard calls the report, which
is created from a quary and a report. As they only want the particular ID to
be printed, they have this as the criteria for the employee ID.
"[Forms]![main]![Applicant].[Form]![ID]"

This all works great. However, the client wanted to add 2 extra pages that
also fills out the info for the employer to sign. The problem (for me
anyways) is that this is from a 2nd table. I tried to go in and add the
second table to the quary. However, as soon as I do that (even before I make
any other changes to the quary) I get as the results the applicants
information listed 55 times. If I delete the 2nd table, it works fine.

Any ideas, oh wise MSDN users?

Thanks in advance!

 

[Marshall Barton]

I am not a big database guy. I had a client call me a few days ago,
however, and asked if I could update a form for him in a MS Access database,
along with some general computer problems. That was something I could do for
him, so I agreed. When I got there, he also wanted me to do some more
extensive changes to MS Access. I'm sure all these things are simple, but I
just don't know how to do them.

The person who created the database (who, of course, is no longer around),
created this database for an employee referral company. The database has a
couple of tables. The first one contains all the applicants (the ones
looking for jobs). Another one contains all the employers. In the database,
they record by ID who the applicant is hired for, etc,etc.

They have a report that they print for the applicant to sign before they
start working for a new company. Their switchboard calls the report, which
is created from a quary and a report. As they only want the particular ID to
be printed, they have this as the criteria for the employee ID.
"[Forms]![main]![Applicant].[Form]![ID]"

This all works great. However, the client wanted to add 2 extra pages that
also fills out the info for the employer to sign. The problem (for me
anyways) is that this is from a 2nd table. I tried to go in and add the
second table to the quary. However, as soon as I do that (even before I make
any other changes to the quary) I get as the results the applicants
information listed 55 times. If I delete the 2nd table, it works fine.

Rather that mess with the working report's query, how about
add the additional data as a subreport (based on its own
query) in the existing report's Footer section.

 

[Michael H. Cox]

Marshall,

Thanks for the quick reply.

I don't know if I know how to do that, but I'll give it a shot.

Thanks so much.

I'll keep you guys posted.

I am not a big database guy. I had a client call me a few days ago,
however, and asked if I could update a form for him in a MS Access database,
along with some general computer problems. That was something I could do for
him, so I agreed. When I got there, he also wanted me to do some more
extensive changes to MS Access. I'm sure all these things are simple, but I
just don't know how to do them.

The person who created the database (who, of course, is no longer around),
created this database for an employee referral company. The database has a
couple of tables. The first one contains all the applicants (the ones
looking for jobs). Another one contains all the employers. In the database,
they record by ID who the applicant is hired for, etc,etc.

They have a report that they print for the applicant to sign before they
start working for a new company. Their switchboard calls the report, which
is created from a quary and a report. As they only want the particular ID to
be printed, they have this as the criteria for the employee ID.
"[Forms]![main]![Applicant].[Form]![ID]"

This all works great. However, the client wanted to add 2 extra pages that
also fills out the info for the employer to sign. The problem (for me
anyways) is that this is from a 2nd table. I tried to go in and add the
second table to the quary. However, as soon as I do that (even before I make
any other changes to the quary) I get as the results the applicants
information listed 55 times. If I delete the 2nd table, it works fine.

Rather that mess with the working report's query, how about
add the additional data as a subreport (based on its own
query) in the existing report's Footer section.