Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    9

    Unanswered: Calculated values in Reports

    Hi
    In a report, in the detail line the text box is "=[field1]+[field2]" and in the grouping line, i had used "=sum([field1]+[field2])" (in both the cases quotes have not been in the file but only to clearly identify them here". While it works in the grouping line, in the detail line it shows the error message "Error".

    How should I go about.

    Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    San Diego
    Posts
    45
    If, by "in the grouping line" you mean in the query builder, you don't need the word SUM. You just need to use the addition operator and it should work.

  3. #3
    Join Date
    Mar 2004
    Location
    San Diego
    Posts
    45
    Also, if you have already added two fields together within your query, you don't need to add them again in the report. Just name a field and add the fields within that field, and then use that field as the control source on your report.

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Hi suresh62

    Not sure what else is going on in your DB but if it works in the GroupHeader/Footer it should work in the DetailSection. Check your spelling if you Typed in the FieldNames. That is a very common thing to happen and so easily overlooked. Also check for Spaces too. I think you have it correct if in the DetailSection you have:

    =[Field1]+[Field2]

    And in the Footer you say it works correctly so that's fine. So check out your Spelling and possible Spaces. The best way to avoid that is to Create it in the ExpressionBuilder by DoubleClicking on the Fields instead of typing. It happens, trust me.

    If that and what LaurelLee has suggested doesn't work I would suggest Zipping and Posting your database for someone on here to fix your problem for you.

    Have a nice one,
    Bud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •