Less Than Symbol

[millertimecu32]

This may sound I guess you could say stupid but...... Is there a way to add a less than symbol in a colum and still keep the value a number rather then text?

 

[boblarson]

no, why do you ask?

 

[boblarson]

You could, however, have the number field and then a qualifier field (text) to be able to set > < >= <= as the qualifiers.

 

[millertimecu32]

I essentially have three columns (result field, reporting limit field and lab qualifier field) that I need to combine to produce one Colum to present in a cross tab query. The issue is that I need to only select the min value for each entry (a given analyte, on a given date, for a given sample location)..... at the same time the values in the reporting limit field need to be posted with a < symbol in front of the value.

 

[Dennisk]

putting a < symbol is just a matter of formatting in the final output or you could just as easily concatenate the symbol at the beginning of the value.

 

[millertimecu32]

I wish it was that simple...
The issue is also enhanced by the following...
If there is a result value in the result column then I need that value in the final column... if there isn't a result value in the result column then I need the value in the Reporting Limit column also this is the value that I need to ad the less than symbol to. I also need to add the qualifier column to the final column as well.

 

[Fifty2One]

your answer is in your own post...
use nested if then else statements and concatenate the < symbol into the appropriate field...