Format Function in Query

[shamas21]

Hi

Im trying to format one of my Crosstab query that has 0 decimals and the theousands seperator

Rate: Format([Testing Rate],"#,##0.00")

I have used the above function to format other fields in other query that are not Crosstabs.

Can someone tell me what im doing wrong or how I can overcome this problem?

Thanks

 

[vbaInet]

In case you didn't know, a field in a query has properties so you can dump #,##0.00 in the format property.

Can you show us a screenshot of what it looks like and what you would like it to be.

 

[shamas21]

In case you didn't know, a field in a query has properties so you can dump #,##0.00 in the format property.

Can you show us a screenshot of what it looks like and what you would like it to be.

Excellent! It solved my problem.

Thank you

 

[vbaInet]

You're welcome!