I have a select query where one of the fields is called value1. Value1 can be 0 or a value higher than 0. Is there a way to build an expression in another column in the query along that says if value1 = 0, then show 0, if value >0, then show 1. I want to be able to sort and group in a report based on if the data is for value1 is zero or or number higher than zero and this is one way I thought I might be able to do it.
I hope that makes sense…
Or, perhaps there is a better way to do it?
TIA
Thanks
