query problem

[ghost]

Hi,
I have two tables. One for employees Info, the other one for employees
completed tasks.
In employee’s info table, employee ID is primary key while in employee
completed tasks table the employee ID is foreign key. Moreover, in the
employee completed tasks table there are more than one tasks for one employee.
I made a query for showing all employee‘s info and task. The problem is when
I run the query, only those who have a record in the employee tasks table
just show, while who do not have record do not appear. I need to sum the
completed tasks even if there is no data. Any help please
Thanks!!!

 

[Jason Lepack]

Double click on the Join between the two tables. Select the option
that says "Select all records for Employees Info and any matching
records from Employee Completed Tasks" or something like that.

Cheers,
Jason Lepack

 

[John Spencer]

Open your query and double-click on the join line between Employees and
Tasks. Select the option for ALL employees and only tasks with ...

Now try your query. If this doesn't solve your problem, then please post
the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..