I recently built a database to help keep track of shipments we are
bringing into the country.
Included in the database are a number of fields with dates for
shipment, ETA etc. Each one of these is accompanied by a "week no"
relating to the week in the calendar year (I am sure many people are
familiar with working with week nos and know what I mean).
Currently the users have to refer to wall calendars which have the
week nos listed on them and manually enter it into the appropriate
field.
Is there any way in which I can have this value calculated
automatically by Access so all the user has to do is enter the date in
the date field and the week no field automatically fills itself in?
It would save us a lot of time....
Many thanks
Simon