Formatting Query output using >

[khunter]

I have a simple query that uses IIf to display what I need. Is there anyway to use say a toupper cmd like you when you put > in the format tab?


Here is the query statement:
SELECT IIf(Left([tblProject]![Tool#],2)="LA",[tblProject]![Tool#],"") AS [Tool#]
FROM tblProject
WHERE (((IIf(Left([tblProject]![Tool#],2)="LA",[tblProject]![Tool#],""))>""))
ORDER BY IIf(Left([tblProject]![Tool#],2)="LA",[tblProject]![Tool#],"")
WITH OWNERACCESS OPTION;

 

[khunter]

Of course I over complicated it...heh heh

toupper is an old C programming term meaning change everything
to upper case.

Thanks for the solid advice once again.