Format error (changes to string undesirably)

[Braino]

 Format (((ZSCORE/(SELECT SUM(ZSCORE) FROM [qry_ZSCORE])) * 3900), "#.00")

Without this formatting i can sort smallest to largest (ideal)
After this formatting i can only sort A to Z (bad)

What i really want is to format it as a "Currency" but when i did that it only allowed me to sort A to Z as well.



Please help, extreme newby.

[JoeM]

The FORMAT function returns (converts to) a String variable.

What you want is the Format property, not the Format function. You should be able to bring up the Properties of the Field or Control you are trying to apply this to, and change the Format property to "Currency".

[Braino]

The FORMAT function returns (converts to) a String variable.

What you want is the Format property, not the Format function. You should be able to bring up the Properties of the Field or Control you are trying to apply this to, and change the Format property to "Currency".

I need to do it in a query, not manually

[June7]

Why do you need formatting in table or query? Why not format in form or report?

[JoeM]

I need to do it in a query, not manually

Fields, even calculated fields, in a query have Format properties.
See here for how to bring that up: http://datapigtechnologies.com/blog/...ousands-place/

[Braino]

Fields, even calculated fields, in a query have Format properties.
See here for how to bring that up: http://datapigtechnologies.com/blog/...ousands-place/

Thanks for the link, that solved my problem, thanks bro!

[JoeM]

Glad to help!