My Querie keeps duplicating

[Lucy02]

Hi

Please can some help me asap. I need to do a querie which joins two tables together. I have a telemarketing table and an appointment table. The idea is that when an appointment is made telemarketing should be done afterwards to the same company. Therefore I want to view all of the telemarketing done and all of the appointments done and then match companies which have had both an appointment and telemarketing. However when i do this if there has been more appointments made for one company that there has been telemarketing the telemarketing duplicates itself so that the two have the same amount done which is not what I want??? Does this make sense?? Can some one please help????

Thanks

 

[Birdy]

Try changing the link on the query to show all records from 1 table and only the matching records from the other.

If this doesn't give the info required, you might have to do a query within a query to get the Main information like Company & Date and then link on these for the query.

 

[Lucy02]

Hi Birdy thanks for the tip. Just a quick question how do i do a query within a query??!! Sorry i'm a newbie to all of this access stuff!!

Thanks

 

[Birdy]

Do a query as normal that gives you the Main info.
Then reference this query in a second query as if it was a table.

 

[Lucy02]

Example:

Appt Day, Date, Month Company Name Tele Day, Date, Month
Monday 1st Nov *Lucy* Wed 12th Nov
Tuesday 2nd Nov *Lucy* Wed 12th Nov
Wednesday 3rd Nov *Lucy* Wed 12th Nov

So what has happend is there have been 3 appointments made but only 1 telemarketing call has been made. However the querie is telling me that 3 calls were made on the 12th when really there was only 1??? Can this be solved???

Thanks ever so much for your help!!

 

[Pat Hartman]

You can't use a single query to return data from non-related tables. Appointments and calls have nothing to do with each other, therefore, they don't belong in the same query. Create a report with subreports to show both appointments and calls.

If you don't need any detail from the calls and appointments, create totals queries so you can summarize the data to one record per customer. Then join the appointments query with the calls query to find the customers with both types of contact.