null values

[ippy]

I've got two tables - one with the all my employees in thier teams and a second one with the a record of all the sales and which employees made the sale. How can I produce a report of the the employees with no sales?

The employees with no sales would not appears in the sales table

Many thanks

[weekend00]

select employeeID, name from employee left join tblsale on employee.employeeID=tblsale.employeeid where tblsale.employeeid is null.

[ippy]

that worked fantastic thanks .... what I'm doing now is trying to include in this formula all of the none sales on certain dates depending on a form value.

I can get a query to pull off all the sales depending on a date selected in a combo box on a form but when I combine to the two queries it gives blank results

-how would i add to the above formula to include a it to only display none sales on a certain date. the date would be determined by a combo box value. Sale Date exsists in the sales table

thanks in advance

[weekend00]

first, find out all employees that have sale during this period, then exclude them:

select employeeID, name from employee left join
( select employeeid from tblsale where tblsale.saledate between #" & me.fromdate & "# and #" & me.todate & "#" )
as b
on employee.employeeID=b.employeeid where b.employeeid is null