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

[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$])

 

[John Spencer (MVP)]

a: [Description] & " $ " & Format(fix( [total$]),"#,###")

 

[RBB]

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$])

.