Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to create a field to convert currencies from one of 2 fields, thus I am putting the following code in "Default Value" as I want this field to be open for my manual input too:

=iif([£ Price]>[$ Price],EuroConvert([£ Price],[GBP],[EUR]),iif([$ Price]>[£ Price],EuroConvert([$],[USD],[EUR]),"0"))

MS Access is giving me this error anytime I try to save the table:

The Database engine could not recognize either the field "£ Price" in the validation expression, or the default value in the table "Table Name".

Worst of all, MS Access isn't providing anything in its knowledge-base about it. Also:

  • I don't have anything in "validation rule"
  • And this is the only "Default Value" Expression I used.
share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.