var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: format a # returned in a qry
I would like to format a # using , seperaters, and have 2 decimal points,
is there a format function and how does it work
Use the VBA Format function:
See Access Help.....
Dim myNumberVariable As Single
Dim MyStrg As String
myNumberVariable = 5459.4
MyStrg = Format(myNumberVariable, "##,##0.00") ' Returns "5,459.40".
Is it actually a query, or are you dumping this into a form/report?
There is a "fixed" format available to forms/reports.
its a query, so i dont think i can use vba, i would use help but the install on this comp is #*()@$ and help often doesnt work
In that case, you do need to use the format function. VBA functions ARE generally available within queries.
Basically you'll end up with:
SELECT Format([myField], "##,##0.00")
format still works in query..
Originally Posted by mikezcg