I have a field in a table (NonRecCostHrsEst) that I'd like to use in a calculation on a report (a form too but I'll stick to one at a time). So, I created a query that has a calculation field: initially called Expr1 and later changed to NonRecCostMoneyEst
In the query design view it looks like this:
NonRecCostMoneyEst: [NonRecCostHrsEst]*50
Datasheet view the calculation is made. The report I'm trying to stick it in is already created. I want to modify it and add that calculated field. Doesnt work. I use the Control Source on the Data tab of Properties. Change it to read:
=[Calculating Costs]![NonRecCostMoneyEst]
On the Print Preview it says #Error.
If I create a new report it shows up. I just dont want to have to go back and make the report over. Clicking and dragging for formatting! Yuck!