Combo box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
For the DNU, just add a Yes/No field. The when you query your data just show those where the DNU = False.
 
Back
Top