MS Access holiday entry

[Ned]

Table with Employees, table with Compensation days and Employee ID. How to
assign Holiday date in Compensation days table to each employee with entering
date of holiday only once of time.

 

[John W. Vinson]

Table with Employees, table with Compensation days and Employee ID. How to
assign Holiday date in Compensation days table to each employee with entering
date of holiday only once of time.

Create a Holidays table with one date/time field, Holiday. Manually enter the
holidays for the next decade or so (c'mon, your company probably only has a
few a year).

You don't say how your "compensation days table" is structured but you could
either use this holidays table in an Append query, or join to it and do an
Update query, or look up its values in code in the data entry form.