Calculate value in subform's textbox

[praveen_khm]

Hi Friends,

Please find the attached screenshot. As usual, am stuck up with a problem from 2 days. (could not attach the file, as its too large)

In the screenshot, there are two fields in the SUBFORM of the Main form.
They are: FTE Count and Mandays.
I need to have FTE count as a calculated field where mandays and month is the input.

Now the problem. There is a table called "Billing days". It gives the number of working days in any month. So, based on that table and the value in the mandays textbox (in the form, with an arrow), I need to calculate the FTE count, which is mandays/number of days(data from billing days). i.e, based on the month, it should pull the data from the billing days table and calculate in the FTE box.

Any suggestions please.

Thanks.

 

[praveen_khm]

Hi Friends,

Please find the attached screenshot. As usual, am stuck up with a problem from 2 days. (could not attach the file, as its too large)

In the screenshot, there are two fields in the SUBFORM of the Main form.
They are: FTE Count and Mandays.
I need to have FTE count as a calculated field where mandays and month is the input.

Now the problem. There is a table called "Billing days". It gives the number of working days in any month. So, based on that table and the value in the mandays textbox (in the form, with an arrow), I need to calculate the FTE count, which is mandays/number of days(data from billing days). i.e, based on the month, it should pull the data from the billing days table and calculate in the FTE box.

Any suggestions please.

Thanks.

ok...herez the attach

 

[praveen_khm]

Hey friends,

Any hope on this???