Is there an easy way?

L

Landor

My wife is a school teacher and is holding a spelling competition for the
school. Each pupil has to both spell and read (pronounce) 200 words. Is there
an easier way to design a table to show which words have been spelled and
read without having seperate fields for spelled and read.

Many thanks

Landor
 
M

m stroup

You could set up a field "status" and have a drop down box with the values
"spelled", "read" or "spelled and read". Then you can query any of the three
options.
 
L

Landor

Many thanks for the prompt reply. I guess I couldn't see the wood for the
trees. It seems so obvious now.
Thanks again

Landor
 
J

Jeff Boyce

Landor

So, you're assuming that each student will, at a minimum, spell or pronounce
the word correctly? What about the option for "none of the above"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
L

Landor

Thanks Jeff,

I think I will add a combo box for each word and give all the options,
spelled, read, spelled & read and none.
That way when a report is printed all bases are covered.

Thanks again

Landor
 
S

Steve

Landor,

A combobox for each word is a bad idea! Consider:

TblPupil
PupilID
etc

TblWord
WordID
Word

TblStatus
StatusID
Status

TblCompetition
CompetitionID
PupilID
WordID
StatusID

In your form to record competition, use an option group (1 - 4) to record
StatusID. All you need to do is check one of the four statuses - much
quicker data entry than a combobox.

Steve
 
Top