Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    > than question in a query

    I use the formula below to tell me if I have an increase over my prior year. It works but displays a -1 or 0 for a value. Any way I can modify this to show the words true or false? Thanks..


    Growth over prior year: [2011 total 30 Days]>[2010 Total 30 Days]

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Try:

    Growth over prior year:iif([2011 total 30 Days]>[2010 Total 30 Days]=true, "True","False")

    This will display the words True or False, and the result will be a piece of text.

    Simpler is to just set the Format Property of the field in the query to True/False. In that case the result will still be a Boolean result, but displayed as the word true or false.
    truefalse.gif
    Regards
    John



Posting Permissions

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