title: multiple currency formats in one column - Access 2007
body: <p>Is it possible to have multiple currency denominations in a field?</p>
  
  <p>I have a field that will have a currency value that will be either euro's or sterling dependent on whether or not the applicable record is in the currency zone.</p>
  
  <p>Is this possible in Access or will i need to have seperate fields for euro/sterling?</p>
  
  <p>Thanks in advance for any help</p>
  
  <p>Noel</p>