Jeff06
08-17-2007, 10:26 AM
select salary, pct
from tally
I want salary to be in this format: $3211.00
pct in 23.00%
How can I do that?
Thanks
from tally
I want salary to be in this format: $3211.00
pct in 23.00%
How can I do that?
Thanks
|
View Full Version : how to control output format Jeff06 08-17-2007, 10:26 AM select salary, pct from tally I want salary to be in this format: $3211.00 pct in 23.00% How can I do that? Thanks statsman 08-17-2007, 10:35 AM select salary, pct from tally I want salary to be in this format: $3211.00 pct in 23.00% How can I do that? Thanks Is this for a report? If so, you don't have to make changes in the query only in the report. Format the text boxes that contain the relevent info to currency and percent. |