How to pull all records in one query if a value exists?

[rreiling007]

Hi Access Experts!

I have a question that might be fairly easy for you.

I have one table let's call is table1. It contains about 5 columns with standard employee data with about 10,000 rows of data containing about 1,150 employees. All employees have multiple rows of data. There is one column titled JOB. I need to pull all rows of data for each employee ONLY if there is at the minimum one value for the employee in the JOB column. I do not want to pull employees that have no values in the JOB column. They can be excluded from the query.

Example of all record for one employee. I need to pull all rows of data ONLY if the employee has a value in the JOB column.

Name EE_ID JOB CAT EFF_DATE

John Doe 1006 CLERK F 01-JAN-2010
John Doe 1006 P 21-JAN-2010
John Doe 1006 CLERK P 01-FEB-2011
John Doe 1006 F 01-MAR-2011
John Doe 1006 P 01-APR-2011
John Doe 1006 CLERK F 01-JUL-2012

Appreciate any guidance you can provide.

Thank you!

 

[pbaldy]

Try

Is Not Null

in the criteria row under that field in design view.

 

[rreiling007]

Thanks.

That will only pull rows where there is a value. I need of there is a value for all rows.

 

[JHB]

Don't double post you (could) waste peoples time!
http://www.access-programmers.co.uk/forums/showthread.php?t=262294