Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    West Yorkshire - UK
    Posts
    6

    Thumbs up Unanswered: Display a numerical figure on a report

    Let's say I have a column of figures on my report, of which the last figure could be either positive or negative. If the last figure is positive, I want it displayed in a specific place on the report, however if the figure is a minus one I want this figure displayed in a specific place.

    eg (if minus) eg (if positive)
    5.50 100.00
    15.80 25.00
    -213.20 150.00



    -213.20 150.00

    Can anyone offer me a solution to this? I can provide more information if so required.

    Thank you.

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: Display a numerical figure on a report

    I hope you are using two separawete text boxes to show +ve and -ve values. If so then in the "On Format event" in detail section of the Report you can evaluate the condition and place the resultant figure in its proper box.

    Originally posted by DesperateDan
    Let's say I have a column of figures on my report, of which the last figure could be either positive or negative. If the last figure is positive, I want it displayed in a specific place on the report, however if the figure is a minus one I want this figure displayed in a specific place.

    eg (if minus) eg (if positive)
    5.50 100.00
    15.80 25.00
    -213.20 150.00



    -213.20 150.00

    Can anyone offer me a solution to this? I can provide more information if so required.

    Thank you.

Posting Permissions

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