Combo box?

V

venusasaboy

Hello

I'm trying to make a column("status") containing a checkbox for my employees, containing three check boxes or a drop down list: New, Old, and DNU

I can't figure out how to format the column showing these three choices

I would like the "new" employees to change to "old" after 6 months if at all possible

Thanks, Jason
 
R

Roger Carlson

Why store New and Old at all? Just store their StartDate and then calculate
it against the current data (using the DateDiff function). Do this in a
query, form, or report. I don't know what DNU is, but if it is some value
that can't be calculated, just create a boolean field (Yes/No) called DNU
and call it good.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

venusasaboy said:
Hello,

I'm trying to make a column("status") containing a checkbox for my
Click to expand...
employees, containing three check boxes or a drop down list: New, Old, and
DNU.
 
A

Allen Pinkley

For the DNU, just add a Yes/No field. The when you query your data just show those where the DNU = False.
 
Top