Based on From Date and to date.. we have to calculate the column

[udaykamble]

Hi,
I m facing with one issue, Please help on this.

we have January, Feb,mar..Upto December. these are the columns.

our requirement is..we have Resource column and Jan, feb, ...upto December columns.

Now we have to calculate total hours worked per resource. here we have to create one query calculation column,and we have to calculate based on From Date and To Date. Here we dont have month column, only we have jan, feb.. upto december columns.

here we need one date prompt.

Please help on this. Its urgent issue.
Advance Thanks for you
... I am waiting for your reply...

 

[drlex]

You might like to follow up Ties' reply to your original thread - thread401-1557924 - and not repeat yourself.

Having said that, I'd consider a UNION view to get a date column to select upon.

soi la, soi carré