Filtering records on highest number

[johnsqftwr]

Hi All,

I have a query which has 3 fields
Employee No:Emp_No
MonName: Which Has the employee's name if he is in on Monday or if not then the filed is blank.
MonNum: This gives a value to the field ie If the employee is in then 1 if not then 0.

If the same employee appears twice then I ONLY need the highest value 1.
Emp_No MonNum
1 1
2 0
1 0

In the above example I only want the first 2 records

Many thanks

 

[Brianwarnock]

Group by emp_no and Max MonNum

brian