Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating in a report (97/SR2)

    I have a report with a count (from a query) of each entry per establishment, with a total at the bottom i.e. a text box with =sum([count]). I have added a text box next to the count which is [count]/[total of count] giving me the percentage for each one - however, i'd like a total of this column in the footer as well and =sum([percentageTxtbox]) doesn't seem to work. I tried writing the contents of the percent box to a variable every Detail Format event and adding it that way but that didn't seem to work either - would anyone have any ideas?
    Any help would be much appreciated.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating in a report (97/SR2)

    Try sum([count]/[total of count])
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating in a report (97/SR2)

    Thank for the suggestion Fancois.

    Just tried it and it then can't find the text box holding the value of =sum([count]).

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating in a report (97/SR2)

    You have probabily a textbox with the name Count.
    In a report you have to rename your textbox's to anything else than the name of field in the underlaying table or query.
    You can do calculations with fields but not with textboxes. If a textbox has the same name as a field, the report is confused.
    Francois

Posting Permissions

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