want the number shown to have commas at the 1000 location.

  • Thread starter Thread starter RBB
  • Start date Start date
R

RBB

I have a simple question, in a Query I want to have a text
and a number fieldjoined together. The resulting text
number field I want the number shown to have commas at
the 1000 location.

NewYork $12345 do not want this
NewYork $12,345 I want this

The following is what I have but no commas.

a: [Description] & " $ " & fix( [total$])
 
Works great, thank you for the help.
RBB
-----Original Message-----
a: [Description] & " $ " & Format(fix( [total$]),"#,###")

I have a simple question, in a Query I want to have a text
and a number fieldjoined together. The resulting text
number field I want the number shown to have commas at
the 1000 location.

NewYork $12345 do not want this
NewYork $12,345 I want this

The following is what I have but no commas.

a: [Description] & " $ " & fix( [total$])
Click to expand...
.
Click to expand...
 
Back
Top