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