--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Russ-
>
> It's not clear what it is you're trying to do.
>
After changing your sys. date to any day in May, then if query1 is run, it updates the table field for the first Sunday in June as June 9th, but the calendar say it's June 2nd.
If the second query (query2) is run, it updates the table of the first Wednesday of June as the 29th of May.
I know that some months have 4 Sundays and some have 5 Sundays and some have 4 Wednesdays and some have 5 Wednesdays. I can handle that problem, but if the "first" Sunday or the "first" Wednesday cannot be calculated for every month, then what?
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar