SQL If statement for formating

[millertimecu32]

Can you do an SQL IIF Statement for formating? I am trying to Bold a value only if the value is greater than a value in another column.

 

[neileg]

Easier to use contitional formatting in your form or report.

 

[millertimecu32]

I would have to do it this way because the final field that is presented is no longer a value rather a text field (i am combining a text field with a number field). Can anyone give me direction as how do SQL IIF statements for formating?

 

[neileg]

You can still use conditional formatting on a text field. SQL doesn't deal with formatting in terms of font or bolding. The only formatting that works in SQL is date, text case and number formats.