Access 2010中的挑战 [英] a challenge in Access 2010
问题描述
挑战在于: 在Access 2010的Web数据库中,名为Assignment的表中有一条记录: EmployeeID = 1,ProjectID = 31,ProjectStartDate = 2/5/12和ProjectEndDate = 12年4月17日。 如何将以下记录生成到另一个表中,
名为AssignmentDateBreakdown:
The challenge is: In a web database of Access 2010, there is one record in a table named Assignment: EmployeeID=1, ProjectID=31, ProjectStartDate=2/5/12 and ProjectEndDate=4/17/12. How to produce the following records into another table, which is named AssignmentDateBreakdown:
EmployeeID ProjectID ProjectStartDate ProjectEndDate
EmployeeID ProjectID ProjectStartDate ProjectEndDate
1               31           2/5/12                 2/28/12
1 31 2/5/12 2/28/12
1               31           3/1/12                 3/31/12
1 31 3/1/12 3/31/12
1               31           4/1/12                 4/17/12
1 31 4/1/12 4/17/12
谢谢,
Jin
推荐答案
可能需要编写一个函数。我可能会问你为什么要这样做?
It would probably require writing a function. Might I ask as to why you would want to do this?
这篇关于Access 2010中的挑战的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!