Validation Rule value

[Cheeseboy]

Hello,
I am trying to make a validation rule which says: the joindate value must be before the expirationdate.

I made this rule:>=[JoinDate] And <[ExpirationDate] but access does not like it.


JoinDate and ExpirationDate are names of columns in my table.


Thanks for your help!

[guelphdad]

Please post in the correct forum, you are using Access and not MySQL but posting in the MySQL forum. you need to post in the other database area. Thread is moved.

[Old Pedant]

... WHERE JoinDate < ExpirationDate ...

No idea why you thought you wanted either >= or AND in there.

And this is still in the wrong forum, you know. A moderator will undoubtedly move it.

************

EDIT: How's that for making a prediction that has already come true? <grin/>