How to generate weeknumber and begin of week date
Hi guys . I got a table in my db called week. It has the following
feilds on it . Year, weekno and monday. I created a button and a text box in the form.
when i type a year name and press a button i want the the follwing happes:
it check if the year exist in the db. if the year does not exist it goes
and inserts week number from 1 -52 along with start of date and year in to the db. I be happy if some one show me how to do this in access.Thanks
|
