H
Henrootje
Hello!
tblROSK
============
ROSK_QuarterNumber Integer 'contains a number that clarifies which
quarter is meant
ROSK_QuarterLength Integer 'should contain the length of the quarter
meant in ROSK_QuarterL
I import a file with data, in that importprocess users enter a value
(eg 54) That means that the data imported is from (5) 2005, (4) fourth
quarter
(1-10-2005 <> 31-12-2005)
(eg 61) That means that the data imported is from (6) 2006, (1) first
quarter
(1-1-2006 <> 31-3-2006)
Now I need to calculate the length of the quarter (x = 31-12-2005
-1-10-2005)
Is there a way to automate this so that the value in ROSK_QuarterLength
calculated based on the contents of ROSK_QuarterNumber ??
tblROSK
============
ROSK_QuarterNumber Integer 'contains a number that clarifies which
quarter is meant
ROSK_QuarterLength Integer 'should contain the length of the quarter
meant in ROSK_QuarterL
I import a file with data, in that importprocess users enter a value
(eg 54) That means that the data imported is from (5) 2005, (4) fourth
quarter
(1-10-2005 <> 31-12-2005)
(eg 61) That means that the data imported is from (6) 2006, (1) first
quarter
(1-1-2006 <> 31-3-2006)
Now I need to calculate the length of the quarter (x = 31-12-2005
-1-10-2005)
Is there a way to automate this so that the value in ROSK_QuarterLength
calculated based on the contents of ROSK_QuarterNumber ??