Need help with an access assignment..

[Bass]

I have two tables, one with a list of clients, client numbers, city names, and their corrosponding technician numbers. The second table is the technicial table. With tech number, first /last name/ city etc. I need to create a query that returns a list of customers with their technicians. I have a technician who has no clients though, and I need to have his name returned aswell. and I am unsure of how to do this.

If anyone can help it would be awesome.

 

[raskew]

Hi -

If you set the relationship to a Left Join (i.e. All records from 'tblTech' and only those from 'tblCust' where the joined fields are equal) that will allow you to return all technicians and their related customers.

HTH - Bob

 

[Rabbie]

Look up LEFT JOIN in Access Help