validation rule restricting currency to $5 and up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Access 2003 and I'm trying to create a validation rule that won't
let data be entered if the amount is below $5.

I've tried the following:

1. Validation Rule: >=$5.00 (With Validation Text "Enter $5.00 or more)
2. Validation Rule: =IIf([Price]< $5.00, "Enter $5.00 or more")

I've tried some variations on these, such as moving quotations, taking out
the beginning equal sign, taking out decimal places, but can't seem to get
past the message:

"The expression you entered contains invalid syntax"

I also get the following expression:

"This expression is typed incorrectly, or is too complex to be evaluated."

Given than the expressions I've attempted don't seem complicated, I'm
guessing that I'm not using the correct syntax, or have not created the
correct variable.
 
ditnog said:
I'm using Access 2003 and I'm trying to create a validation rule that
won't let data be entered if the amount is below $5.

I've tried the following:

1. Validation Rule: >=$5.00 (With Validation Text "Enter $5.00 or
more) 2. Validation Rule: =IIf([Price]< $5.00, "Enter $5.00 or more")

I've tried some variations on these, such as moving quotations,
taking out the beginning equal sign, taking out decimal places, but
can't seem to get past the message:

"The expression you entered contains invalid syntax"

I also get the following expression:

"This expression is typed incorrectly, or is too complex to be
evaluated."

Given than the expressions I've attempted don't seem complicated, I'm
guessing that I'm not using the correct syntax, or have not created
the correct variable.
Click to expand...

As long as the field in question is numeric, it should be enough
with only: >=5
 
Ok, thanks again! I was making it much more difficult than it needed to be. I
wasn't sure if I needed to indicate that it was currency with two decimal
places. Looks like the answer is "no." I tested it in my data sheet and it
works.

RoyVidar said:
ditnog said:
I'm using Access 2003 and I'm trying to create a validation rule that
won't let data be entered if the amount is below $5.

I've tried the following:

1. Validation Rule: >=$5.00 (With Validation Text "Enter $5.00 or
more) 2. Validation Rule: =IIf([Price]< $5.00, "Enter $5.00 or more")

I've tried some variations on these, such as moving quotations,
taking out the beginning equal sign, taking out decimal places, but
can't seem to get past the message:

"The expression you entered contains invalid syntax"

I also get the following expression:

"This expression is typed incorrectly, or is too complex to be
evaluated."

Given than the expressions I've attempted don't seem complicated, I'm
guessing that I'm not using the correct syntax, or have not created
the correct variable.
Click to expand...

As long as the field in question is numeric, it should be enough
with only: >=5
Click to expand...
 
Back
Top