How do you set up an "OR" field

[Ernie Hastings]

Hi,

I am trying to set up a mailing list in a database and 2 of the fields I
wish to set up as a single digit entry.

The fields are State/Independent and Primary/Secondary.

I wish to be able to input either S or I in the first field and P or S in
the second one.

Later I wish to be able to search on one of these fields to send out a
letter, ie to all independent schools search on "I"

Any help will be appreciated.

TIA,

ErnieH

 

[John Vinson]

Hi,

I am trying to set up a mailing list in a database and 2 of the fields I
wish to set up as a single digit entry.

The fields are State/Independent and Primary/Secondary.

I wish to be able to input either S or I in the first field and P or S in
the second one.

Later I wish to be able to search on one of these fields to send out a
letter, ie to all independent schools search on "I"

Simply open your Table in design view and add the two new fields. Make
them of Text type, and in the size field at the bottom of the screen
change the default 50 bytes (or possibly 255), to 1.

Use a Form to enter data into the table; and bind a Combo Box to each
of these fields. Use the combo box wizard and choose the option to
type in a list of values. Use "S" or "I", or "P" or "S" as needed.

Base your Report that prints the mailing labels/envelopes on a Query
selecting the desired value.

John W. Vinson[MVP]