> than question in a query

Topic

New Reply

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]

Reply | Quote

Replies

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.
27566-truefalse

Reply | Quote