All,
Im after some help regarding a query problem i have
Please have a look at the attached pic DD2,
The result of running the query is shown in attched pic DD3
Basically what i need is for total2 to return a value of 2 or 0
If the value of total is greater that 6.1 it needs to return 2 if its less that 6.1 it needs to return 0
Many thanks in advance
Steve