Taking out Repated data in a query

  • Thread starter Thread starter Andy Morgan
  • Start date Start date
A

Andy Morgan

Please can anyone help
I have got a query that pulls information from a table
between two dates, sometimes there are two valid records
that match the critera but I only wont to show one record
in the query e.g. one person can be late for work twice in
a month but I only wont to show there name once.

I am using a single table to get the information.

Please can someone help I have tried using the "first" in
the total row but it is not working for some reason.

Please help

Cheers
 
Andy,

Group By is the tortals function you need on the name field, First will only
return one person even if there are more, provided you get the rest right.
You must also make sure you use Where on the date field, or it will result
in multiple records being returned (and most likely the source of your
problem is here).

HTH,
Nikos
 
Back
Top