sorry, i forgot to mention that i need the currency formatted in Japanese Yen. but you put me on the right track.
i ended up just typing in the yen symbol and using
formatnumber(rs.Fields("price").Value,0
to get rid of the dollar sign and decimal places.
thanks a bunch,
Jonah