Is there an easy way?

  • Thread starter Thread starter Landor
  • Start date Start date
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
 
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.
 
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
 
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
 
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
 
Back
Top