Combine fields in a query

[LSGKelly]

Hi all. I need to combine two fields that contain numbers that are in a currency format (Ex: $1,500 $3,500). When I combine them, I want them to look like this -- $1,500/$3,500. When I combine them in the query, they look like this 1500/3500. Is there a way to combine and retain the currency format?

Thank you!

Kelly

[LSGKelly]

Nevermind, I figured it out!

Thanks anyway. lol