Date field -

  • Thread starter Thread starter van
  • Start date Start date
V

van

Hi

I have a form in which a user enters various pieces of data, including some
dates. There is a field for completion date, and I would like for the user
to be able to enter either a date or a week number. Something similar to
the function =WEEKNUM that can be used in excel. How would I implement this
feature into access to facilitate entry of either a date ora number ?

Thanks
 
Van,

This is not possible. Not in the same field, anyway. You could have
two fields, one for CompletionDate, and the other for WeekNumber, and
the user can use one or the other... but it doesn't sound like this is
what you want.
 
Back
Top