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.
 
Thanks, EPM and John,

that's what I had in mind as well...just needed to confirm

Kostas
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Choose between Currency and Euro? 5
Currency and euro in reports 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Multiple Currencies: Strawman 4
The death of music TV channels in UK - but not Europe? 4
Currency format 1
Multiple currency symbols on form? 2
Loop through a record set to change a currency field based on average difference of two fields 0

Back
Top