Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unanswered: Sum of unbound text field

    I know this is really simple, but I'm having a major mental block.

    I have a calculated, unbound text field with the following control source in the Detail section of a report. The field name is "txtUSD_urgl"
    =IIf([C_CNCY]="JPY",([A_URGL_AMT]/[A_LAST]),IIf([C_CNCY]="CAD",([A_URGL_AMT]/[A_LAST]),([A_URGL_AMT]*[A_LAST])))

    I am trying to Sum that field in the Footer section, but I keep getting an Input Box for the above field when I run the report--like it is looking for a parameter. The Sum field's control source is =Sum([txtUSD_urgl]).

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    If the textbox name txtUSD_urgl is in the Detail section of the report, then my only guess is there is a typo in the Sum. It should work.


    If you can't quite figure it out, another way to do it is to use a query to do the calculation for you. If the report is based on a query alreayd then add a field:

    USD_urgl:=IIf([C_CNCY]="JPY",([A_URGL_AMT]/[A_LAST]),IIf([C_CNCY]="CAD",([A_URGL_AMT]/[A_LAST]),([A_URGL_AMT]*[A_LAST])))


    Or if the report is based on a table then make it based on a query with that field.

  3. #3
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    133
    I'm not sure why it is, but it won't let you sum a field in the detail section from the footer.
    What works for me is to put a textbox in the DETAIL section with a control source of =Sum([txtUSD_urgl]) and set its Visible property to false. Then refer to that textbox from the textbox in the footer.

Posting Permissions

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