I have two separate fields: one is text, one is a dollar amount (i.e. 5,000)
Is it possible to combine the two and have the number show with teh comma?
Right now - I did the formulas as
= [Text] & " " & [Number]
and it shows up as say : Text 5000 instead of Text 5,000