date calculation

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

Guest

Hi,
have a table with the following fields in
record_num (auto num)
Comp_type (text field for description)
Comp_time (field for working days)

the date looks like this
1 assult 1
2 violence 5
3 rubbish 10

What i need to achieve is this table will be a drop down list in a form
which the user will select one of the possible's
What has been requested is that the Com_time field then crates a auto date
in another field called Target_date which will be todays date plus the value

kind of target_date= Date + comp_time
Question is is this possible and can working days be built into it ???

All help greatly appreciated
 
Yes, it is possible.

Create a textbox on the form. For the Control Source of the textbox, use an
equation that refers to the values desired. For the Number of Days, you
would refer to the third column of the combo box. You don't need to display
this column in the combo box if you don't want to. You can hide it by
setting its Column Width to zero.

=Date()+cboMyCombo.Column(2)

The Column value is zero based, so 2 is the third column.

--
Wayne Morgan
MS Access MVP


"(e-mail address removed)"
 
Back
Top