Two different currencies?

  • Thread starter Thread starter Kostas
  • Start date Start date
K

Kostas

I have a music db where I d like to have a purchase_price field.
I bought half of my cd's in Europe and others in the US, and was keeping
track of most prices I payed in an excel file so that I can enter those
values in the db but half of them are in Euros and the other half in
dollars.
Is there any workaround for using multiple currencies in one field?

K
 
I have a music db where I d like to have a purchase_price field.
I bought half of my cd's in Europe and others in the US, and was keeping
track of most prices I payed in an excel file so that I can enter those
values in the db but half of them are in Euros and the other half in
dollars.
Is there any workaround for using multiple currencies in one field?
Click to expand...

Not that I can think of. What you might want is two fields - a price
field (Currency datatype) and a second field indicating the currency
type.
 
Back
Top