a status like "checking" to change to date format when completed

[chynewalker]

I am creating a DB that is for Tracking engineering drawings.

I want to have a status field that has the following

1. not started
2. in process
3. in checking
4 complete / Date completed

Is it possible to have the complete status change to a date somehow?

I want to avoid having two fields, a status field and a complete field

 

[kc-mass]

I would suggest that you may want to change that to have four date fields.

DateReceived
DateStarted
DateReviewStarted
DateComplete

That way you can easily check its status in the process and get a complete
timeline.

but to answer your specific question:

use a text field and when completed stuff it with = Cstr(Date)

If you later have to change it back to a date to do some math use
CDate(TextField)

Regards

Kevin

 

[John W. Vinson]

I am creating a DB that is for Tracking engineering drawings.

I want to have a status field that has the following

1. not started
2. in process
3. in checking
4 complete / Date completed

Is it possible to have the complete status change to a date somehow?

I want to avoid having two fields, a status field and a complete field

Not really. You could have a Text field and store a date converted to text
into it... but it wouldn't really be a Date/Time field (which is stored as a
number), and could lead to difficulties in searching or sorting dates
chronologically. I'd just use two fields (that's not going to overburden a
well designed database); you could use a Combo Box for the status field, and
use its AfterUpdate event to automatically set the date completed when
Complete is selected.

 

[GP George]

Actually, no. A date is a date and a status is a status and never the twain
shall mix.

Having two fields is the right way to go. Besides, there is nothing that
says you can't record a status date for "in process" to indicate the day the
work started, etc.

George

 

[mondomaine]

I am creating a DB that is for Tracking engineering drawings.

I want to have a status field that has the following

1. not started
2. in process
3. in checking
4 complete / Date completed

Is it possible to have the complete status change to a date somehow?

I want to avoid having two fields, a status field and a complete field