| | |
|
|
|
Combo box? |
|---|
| message from =?Utf-8?B?dmVudXNhc2Fib3k=?= on 21 May 2004 |
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
|
| Roger Carlson replied to =?Utf-8?B?dmVudXNhc2Fib3k=?= on 21 May 2004 |
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.
|
| =?Utf-8?B?dmVudXNhc2Fib3k=?= replied to Roger Carlson on 21 May 2004 |
I had thought about using an entry date to sort, but the problem is that I have a halfway completed database, so I'm entering employees who might have applied in 1995, and at the same time I'm entering new employees as they arrive. So I would like to be able to distinguish.
DNU - "Do Not Use"
|
| =?Utf-8?B?QWxsZW4gUGlua2xleQ==?= replied to =?Utf-8?B?dmVudXNhc2Fib3k=?= on 21 May 2004 |
For the DNU, just add a Yes/No field. The when you query your data just show those where the DNU = False.
|
|
Archived message: Combo box? (Microsoft Access Database)
