Sub criteria

  • Thread starter Thread starter Denise B
  • Start date Start date
D

Denise B

Hello,

I am working will a database that has feilds related to
staffing. For each of the feilds there are criteria such
as Sick Employees - this is paid
Suspended Employees - this is unpaid
Maternity - this is unpaid

Is there anyway I can define these feilds on the design
view of my table or will I have to create a whole new
field for Paid/Unpaid? In my report I would like to see
all of my feilds with subtotals for Paid and Unpaid.

Thank you,

Denise
 
Add another table which has two fields
AbsenceType (text)
Paid (Yes/No)

AbsenceType Paid
Sick Yes
Suspended No
Maternity No

etc

That way if you decide to pay Maternity leave (that would be nice!) you only
have to change it in one place, instead of changing it for every time it
happened using a new field in your current table. Link the AbsenceType
together for these two tables.

HTH
Mich
 
Back
Top