Show all Records

[Guest]

I have an Emp Absence table which logs the total [days absent] and also the
[number of absences] (i.e. an emp might have long term sick of 100 days but
still only 1 absence). I want to create a query which returns all emps who
have had 3 or more absences - I want this to show ALL absences for the
[EmployeeID] which has had over 3, (inc the detail) not just the ones which
are >=3, at the moment only absences against the 3 or more are returned..
How do I do this??

Any help appreciated!

 

[Van T. Dinh]

Does each Record corrspond to one Absence?

Is [Number of absences] a Field in this Table?

 

[Van T. Dinh]

How do you record in your Table structure that an Employee is absent for 10
consecutive weeks (which means that there will be 10 or 11 Records in your
Table since the period can span 10 or 11 weeks) but only 1 Absence for these
10-11 Records?

I don't know your Table Structure but it sounds to me that you have the
entity "Absence" which should translate into a Table "tblAbsence" with the
proviso that one record corresponds to one absence. From your description,
it sounds to me that one record can correspond to multiple Absences and
multiple Records can correspond to one Absence which will make the required
query difficult (and I am not even sure if it is possible!).