Update query

[coyne]

How can I make an update query to fill a new table with monday dates for the whole year?


Thanks

 

[Rich]

Is there a logical reason for storing what's probably redundant information, give us some more details I suspect there are better ways

 

[coyne]

It's like a calander showing who's working for each week. I'd like to have it set up for the whole year. is therre a better way to do this?



-

 

[FoFa]

This can be interesting. If you need a calendar, creating a table with one is not a bad approach. You can track holidays, all kind of stuff, including Mondays. However if the only need you have is to get each Monday, I would just write a VB function that would take a date as a parameter, calculate the (last or next or whatever) Monday from the date given. Than use that to get it on the fly. At least there would be no maintanence that way. If you had a table of Mondays, you would have to regen it ever so often, and that one time you are on vacation, and forgot, it will run out. DATEPART will return a weekday for you.

 

[coyne]

That sounds like it might work but how would i do that, do I somehow use the DATEPART function in the default value of the table or would it have to be VBA atached to a update form? My VBA skills are not that great so I might need help with that.
I might want to just stick with the table of mondays, that way I could chage values a couple months in advance.



thanks

 

[FoFa]

Here is something to give you an idea, open the form, Use A (After) B (Before), put a date in the top box, press the button, see the Monday in the bottom box

 

[coyne]

Thanks, thats pretty cool. I'll post again if I have any problems. but I think that should work.

 

[Rich]

This will also give you a list of Mondays if you wish