yes/no

[LMB]

Hi Guys,

Access 2000. In my employee database I need to print out a report with all the employees listed and their phone numbers. We will use this list for 2 things. One would be if there was a disaster and in this instance we would be able to call every employee to ask for help. Second would be just to offer hours when the census is high or someone called in sick. In this instance we can not call people who do not wish to be called to work extra hours. My plan was to add a yes/no field in my main table (EmpCallList) and then to use conditional formatting in my report to shade in the people who do not want to be on the call list. Is this the way to handle this?

Something like this.

tblEmployee
EmployeeID
EmpLName
EmpFName
Etc.....
EmpCallList

Thanks,
Linda

 

[Ken Snell [MVP]]

Your approach is reasonable... but if you think you'll have other "criteria"
for the employees (such as "this employee is located within 2 miles of the
office", or so on), then I'd use a junction table that allows you to assign
multiple criteria to a single employee (of course, you'd need a parent
Criteria table). You then could run reports for any of the criteria by
testing the employee to see if there is a specific criterion in the junction
table or not for that employee.

Your idea of using conditional formatting will work either way.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Access 2000. In my employee database I need to print out a report with all
the employees listed and their phone numbers. We will use this list for 2
things. One would be if there was a disaster and in this instance we would
be able to call every employee to ask for help. Second would be just to
offer hours when the census is high or someone called in sick. In this
instance we can not call people who do not wish to be called to work extra
hours. My plan was to add a yes/no field in my main table (EmpCallList) and
then to use conditional formatting in my report to shade in the people who
do not want to be on the call list. Is this the way to handle this?

Something like this.

tblEmployee
EmployeeID
EmpLName
EmpFName
Etc.....
EmpCallList

Thanks,
Linda