If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trying to quary two tables
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! |
#2
|
|||
|
|||
Michael H. Cox wrote:
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. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
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. "Marshall Barton" wrote: Michael H. Cox wrote: 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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Criterion - How to Write Query for Multiple Tables | jcinn | Running & Setting Up Queries | 1 | February 8th, 2005 12:42 PM |
need to join local tables with sql 7 tables using guids | Susan via AccessMonster.com | Running & Setting Up Queries | 0 | January 31st, 2005 08:58 PM |
Linked tables | Loi | New Users | 1 | January 26th, 2005 08:57 PM |
Mutliple Tables lookup? | Westley | Database Design | 4 | June 15th, 2004 01:07 AM |