Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006

    Report Calculation

    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!

  2. #2
    Join Date
    Dec 2005
    Wilmington, DE - USA
    When you click in the controlsource for the textbox properties, do you get a drop-down indicator? If you click it, does it show the field from the query? (It should...)

  3. #3
    Join Date
    Mar 2006
    No. Because the report is based on a table. It shows the fields from the table. I tried to use the expression builder for the field I want to use in the query but that brings the error message.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Calculation Help
    By edge5511 in forum Programming
    Replies: 4
    Last Post: 12-18-2015, 11:11 AM
  2. Calculation is off by a few cents...
    By Jule in forum Reports
    Replies: 3
    Last Post: 05-01-2006, 01:06 PM
  3. Calculation
    By thestclair in forum Reports
    Replies: 1
    Last Post: 04-29-2006, 11:03 AM
  4. Date Calculation within same fields
    By mslieder in forum Queries
    Replies: 3
    Last Post: 01-26-2006, 10:08 AM
  5. Subform vs main form calculation
    By fadone in forum Forms
    Replies: 17
    Last Post: 12-21-2005, 07:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums