Validation Rules in Access

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

Guest

I am currently working on creating validation rules for an order form for m y
database but I have become unable to allow Access to accept it. What I
wanted the entity to do was work out...
If member discount is less than £10.00 then enter £3.00 otherwise, enter £0.00
I tried entering the following...
=IF [Subtotal_2] <£10.00 THEN £3.00 IF [Subtotal_2] >£10.00 THEN £0.00
but that didn't work so i took about the pounnd signs, still nothing... so i
tried
=IF [Subtotal_2] <£10.00 THEN £3.00 ELSE £0.00
Nothing!
Please help me!
 
Answered in other thread, which duplicates this one except for the subject
line you used.
 
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

Vlaidation rule help! 1
how to subtract whole #s but not fractions.. 5
Joining up data points 2
How to calculate shipping costs based on subtotal 3
scatter plot 2
Scatter Chart 1
If A1=HR then... 6
(ADO)Getting data from access database Memo field 3

Back
Top