Display Fields with only money values (1 Viewer)

[Tor_Fey]

Afternoon All;

I have a query as per screen show below; is there a way to make it display where the 'qtr's' value is '1' show the value of 'SumOfTF_Ben_O/P' otherwise display value as: £0.00?

So as it is now; in the query the values are displayed as:

financialyear        SumOfTF_Ben_O/P       Qtr1   Qtr2  Qtr3  Qtr4
17/18                   £5,000.00          0       0       1      0
17/18                   £1,400.00          0       1       0      0

What i would like to do is, if the value of any 'Qtr' is 0 then display the value of 'SumOfTF_Ben_O/P' as £0.00, but if the value of any 'Qtr' is 1 then display the value of 'SumOfTF_Ben_O/P' for that record.

So displayed example would be:

financialyear            Qtr1       Qtr2            Qtr3               Qtr4
17/18                     £0.00     £1,400.00    £5,000.00              £0.00

I hope i have explained this correctly, your help as always is appreciated.

Kind Regards
Tor Fey

 

[isladogs]

This should do it

IIf([QTR'S]=1,[SumOfBenTP_o/p],0)

Also you need to format the textbox as currency

NOTE: There may be typos. You need to fix your naming system.
There should be no spaces and no special characters such as / or '

 

[Tor_Fey]

Hi Ridders;

This is perfect, I have it working as needed.
Thank you so much for all your help once again.

Regards
Tor Fey

This should do it

IIf([QTR'S]=1,[SumOfBenTP_o/p],0)

Also you need to format the textbox as currency

NOTE: There may be typos. You need to fix your naming system.
There should be no spaces and no special characters such as / or '

 

[isladogs]

You're welcome
BTW It was hard work typing that code on my phone due to all the 'oddities' ...

IIf([QTR'S]=1,[SumOfBenTP_o/p],0)