[AccessD] query table

You would create and outer join with the parameter saying you want ALL
the records from the date range table regardless of if they have a
match in the employee table. Then you put a criteria on the employee
number to only include those that are NULL in the result set.

GK

On Fri, Jan 13, 2012 at 4:26 PM, Steve Turner <sturner at mseco.com> wrote:
> List,
>
>  I have a table that I pull employee records by date range. I have
> another table I need to check for employee number to see if the employee
> is not there.
>
> Using the simple query linking the tables to employee number on inner
> join that checks date range for all records only pulls records that
> match. How do I make only the records in the date range table show up if
> they are missing in the other table. I am using AK2010.
>
> Steve A. Turner
> Controller
> Mid-South Engineering Co. Inc
> P.O. Box 1399
> Hot Springs, AR 71902
> E-Mail: sturner at mseco.com and saturner at mseco.com
> Phone: (501)321-2276
> Fax:     (501)321-4750
> Cell:     (501)282-7751
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-- 
Gary Kjos
garykjos at gmail.com