how do i make a query format only if certain criteria are met?

[rovolution2]

I want to make a query only do formatting if a certain set of criteria are met (field value does not equal 0 or null).

Can i do this after i type the SELECT statement, such as:

SELECT IIf([Field] = 0 OR [Field] IS NULL, [Field] AS [FieldRep], Format([Field] AS [FieldRep], '0.00%')) FROM table;



Is a statement like the above possible? Thanks

 

[khawar]

SELECT IIf(([Field] = 0 OR ISNULL[Field]) , [Field] AS [FieldRep], Format([Field] AS [FieldRep], '0.00%')) FROM table;

 

[khawar]

Sorry Pat I overlooked that part of the statement