How do I apply validation rule only to new data. For example, I want some of my old customers to have 50% discount while new customer has a discount limit of only 30%?
Kevin Robertson
@Reply 4 years ago
At your level your best option would be an IIF Function in a query.
Keep working trough the classes. This function is covered in Expert Level 8
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.
