Validation Rule Inquiry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bonnie A - 11 Sep 2007 17:26 GMT

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,

Signature

Bonnie W. Anderson
Cincinnati, OH

Reply to this Message

KARL DEWEY - 11 Sep 2007 17:48 GMT

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

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

Signature

KARL DEWEY
Build a little - Test a little

> Hi there! Using A02 on XP.
>
[quoted text clipped - 15 lines]
>
> Thanks in advance,

Reply to this Message

Bonnie A - 13 Sep 2007 13:38 GMT

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!

Signature

Bonnie W. Anderson
Cincinnati, OH

> Use this ----
> "1" Or "2" Or "3" Or "4" Or "5"
[quoted text clipped - 20 lines]
> >
> > Thanks in advance,

Reply to this Message

Jamie Collins - 18 Sep 2007 15:20 GMT

On Sep 11, 5:48 pm, KARL DEWEY <KARLDE...@discussions.microsoft.com>
wrote:

> "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.

--

Reply to this Message

Larry Daugherty - 12 Sep 2007 02:16 GMT

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

Signature

-Larry-
--

> Hi there! Using A02 on XP.
>
[quoted text clipped - 15 lines]
>
> Thanks in advance,

Reply to this Message