Hello All,
I have an Access table – tbl_BgtYrHrs – that has three fields and values like:
I have a report where users can choose a budget year as a parameter value. I want to use the value of the ‘total_hrs’ field in a formula for use in other calculations.
I’m trying to write a formula that’s placed in group and report footers like:
If {tbl_BgtYrHrs.budget_yr} = Year(CurrentDate) Then "Grand Total (" & CStr({tbl_BgtYrHrs.total_hrs },0) &"): "
However, I’m not getting the correct values for clients that have two records in the table like ‘AcmeCo’.
Can anyone tell me how to get this right?
Any/all help would be greatly appreciated!
Thanks,
- tm
I have an Access table – tbl_BgtYrHrs – that has three fields and values like:
Code:
client_name budget_yr total_hrs
AcmeCo 2006 500
GenCo 2006 200
DataCom 2006 300
AcmeCo 2007 600
I have a report where users can choose a budget year as a parameter value. I want to use the value of the ‘total_hrs’ field in a formula for use in other calculations.
I’m trying to write a formula that’s placed in group and report footers like:
If {tbl_BgtYrHrs.budget_yr} = Year(CurrentDate) Then "Grand Total (" & CStr({tbl_BgtYrHrs.total_hrs },0) &"): "
However, I’m not getting the correct values for clients that have two records in the table like ‘AcmeCo’.
Can anyone tell me how to get this right?
Any/all help would be greatly appreciated!
Thanks,
- tm