adding dollar signs in a field in table

[Lifeseeker]

Hello,

I have a dollar value field in the database, but the problem is that not all values have a dollar sign in front.

So I'm thinking I need an update query to append a dollar sign in front of all the numbers.

How do I do that?

Thanks for comments

 

[jdraw]

Is the data type of this field Currency?

 

[Lifeseeker]

Oh right....How can I forget..thank you for mentioning it.