By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 982 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

data weekly- monthly

P: n/a
I have a table with 2 fiels, F1 contain dates and F2 contains numeric.
I have a control on the form and i wand to have the data monthly - weekly
like this,
according with the month of the control on the form:

Day (from F1) Value(from F2)
1st week of month
Mo (31st day previous month) -
Tu (1st day current month) 12
We (2 current month) 3
Th 5
Fr 21
Sa 2
Su 11
second week of month
Mo 26
Tu 12
We 3
Th 5
Fr 21
Sa 2
Su 11

3th week of month
Mo 15
Tu 12
We 3
Th 5
Fr 21
Sa 2
Su 11
4th week of month
Mo 15
Tu 12
We 3
Th 5
Fr 21
Sa 2
Su 11
5th week of month
Mo 23
Tu 12
We 30th day of current month) 3
Th (1st day of next month ) --
Fr (2nd day of next month --
Sa (3th day of next month --
Su (4th day of next month --
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.