从我的数据填充计划并将其附加到表中 [英] Populating a schedule from my data and appending it to a table
本文介绍了从我的数据填充计划并将其附加到表中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在努力寻找能够帮助我编写代码的人,这样我就可以在随机事件过程中计算出天数....我有每个周期的天数,所需的周期数和开始日期。我必须能够通过单击CmdButton来填充计划。
这可能吗?任何人都可以建议任何其他方式做到这一点:)
请参阅附件数据库。
I have am trying to find someone who is able to help me write a code so i can calculate the ''days on'' in a course of random events.... I have the Number of days in each cycle, the number of cycles required and a start date. I have to be able to populate the schedule from clicking a CmdButton.
Is this possible? Can Anyone Suggest a way of doing it any other way :)
See the attached database.
推荐答案
不完全确定你的意思是什么,但如果你正在寻找
Not exactly sure what you mean by the above Statement, but if you are looking for
展开 | 选择 | Wrap | 行号
Even虽然在一个周期中可能有'n'个天数,但我想找到该周期中特定日期的日期...
例如:
在任何14天的周期中,我必须在第2天,第11天,第14天给妈妈打电话。我的第一个电话是在01/01/2010。我必须重复这个循环3次。所以....
周期日日期日期将附加到新表:
1 1 01/01/2010
1 2 02/01/2010 X
1 3 03/01/2010
1 4 04/01/2010
1 5 05 / 01/2010
1 6 06/01/2010
1 7 07/01/2010
1 8 08/01/2010
1 9 09/01/2010
1 10 10/01/2010
1 11 11/01/2010 X
1 12 12/01/2010
1 13 13/01/2010
1 14 2010年1月14日X
2 1 15/01/2010
2 2 16/01/2010 Y
2 3 17/01 / 2010
2 4 18/01/2010
2 5 19/01/2010
2 6 20/01/2010
2 7 21/01/2010
2 8 22/01/2010
2 9 23/01/2010
2 10 24/01/2010
2 11 25/01/2010 X
2 12 26/01/2010
2 13 27 / 01/2010
2 14 28/01/2010 X
3 1 29/01/2010
3 2 30/01/2010 X
3 3 31/01/2010
3 4 01/02 / 2010
3 5 02/02/2010 X
3 6 03/02/2010
3 7 04/02/2010
3 8 05/02/2010
3 9 06/02/2010
3 10 07/02/2010
3 11 08/02/2010 X
3 12 09/02/2010
3 13 10/02/2010
3 14 11 / 02/2010 X
Even though there may be ''n'' number of days in a cycle, i want to find the date for a specfic date in that cycle...
for example:
In any 14 day cycle, I have to phone my mum on day 2, day 11, day 14. My first phone call is on 01/01/2010. I have to repeat this cycle 3 times. So....
Cycle Day Date Dates to be Appended to new table:
1 1 01/01/2010
1 2 02/01/2010 X
1 3 03/01/2010
1 4 04/01/2010
1 5 05/01/2010
1 6 06/01/2010
1 7 07/01/2010
1 8 08/01/2010
1 9 09/01/2010
1 10 10/01/2010
1 11 11/01/2010 X
1 12 12/01/2010
1 13 13/01/2010
1 14 14/01/2010 X
2 1 15/01/2010
2 2 16/01/2010 Y
2 3 17/01/2010
2 4 18/01/2010
2 5 19/01/2010
2 6 20/01/2010
2 7 21/01/2010
2 8 22/01/2010
2 9 23/01/2010
2 10 24/01/2010
2 11 25/01/2010 X
2 12 26/01/2010
2 13 27/01/2010
2 14 28/01/2010 X
3 1 29/01/2010
3 2 30/01/2010 X
3 3 31/01/2010
3 4 01/02/2010
3 5 02/02/2010 X
3 6 03/02/2010
3 7 04/02/2010
3 8 05/02/2010
3 9 06/02/2010
3 10 07/02/2010
3 11 08/02/2010 X
3 12 09/02/2010
3 13 10/02/2010
3 14 11/02/2010 X
这绝对是''可能'' - 让我在脑海中解决逻辑问题,而且我LL拿出东西给你。请继续关注...
P.S. - 02/02/2010 不应该是结果集的一部分,是吗?
This is definitely ''possible'' - just let me work out the logic in my mind, and I''ll come up with something for you. Stay tuned...
P.S. - 02/02/2010 should not be part of the Result Set, should it?
这篇关于从我的数据填充计划并将其附加到表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文