Getting % and $ signs in the query

[accessaspire219]

Does anyone know how to get the % sign and $ sign to display on query results? I think there must be a way a function to format the output, I dont know what it is though. Also will the formatting get copied over to excel when the output is copied?

 

[ajetrumpet]

yes. put them in as a string. example, if you want a field that has a long number in it, and you want to display it as a currency, do this:

SELECT "$" & columnname

you can also use conversion functions (look them up in the help menu), like this:

SELECT ccur(columnname) as ALIAS NAME

 

[Rich]

You could of course try using the property sheet for the field in the query

 

[gemma-the-husky]

except that logically, the concept is meaningless

how can a number be both a currency and a percentage? I can't envisage such a number.

 

[accessaspire219]

Dave it is for two distinct columns one is a currency column and the other is a percent column