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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Week number 3
Excel Vba to change displayed year automatically. 14
Forcing a date entry format of dd/mm/yyyy 1
formating a date entered in one column to appear as a wk num in ne 2
Automatically dateadd a date to a from 1
Excel How to get the number of days an item was opened from the today's date. 14
Deny changing value in field, based on values of multiple fields 4
Check for duplicate with multiple criteria 4

Back
Top