Validation Rule Inquiry

[Guest]

Hi there! Using A02 on XP.

I know this is a SIMPLE thing but Access Help is not helping me.

I have 2 single character text fields. One can only be 1, 2, 3, 4 or 5 and
the other can only be A, B, C, D or E.

I've tried =1, or 2, or 3

I've tried ="1", or "2"

I've tried 1;2;3;4;5

I've tried alot of things and none are working. And I'm sure it's simple to
the initiated.

I would really appreciate your advice.

Thanks in advance,

 

[Guest]

Use this ----
"1" Or "2" Or "3" Or "4" Or "5"

"A" Or "B" Or "C" Or "D" Or "E"

 

[Larry Daugherty]

Have you tried solving your issue in parts? I.e. get something to
work with just the number character, then get just the alpha character
to work and then concatenate them with an AND. Help seems pretty good
on this one.

HTH

 

[Guest]

Good morning Karl,

Thank you VERY much for the response. I knew I was missing something
obvious.

I really appreciate you being part of the newsgroups and helping out so many!

 

[Jamie Collins]

"1" Or "2" Or "3" Or "4" Or "5"

"A" Or "B" Or "C" Or "D" Or "E"

Alternatively:

LIKE '[1-5]'

LIKE '[A-E]'

Jamie.

--