Is there an easy way?

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.
--
Teach me to fish! Thanks for the help.
Pax, M


"Landor" wrote:

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

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

"m stroup" wrote:

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.
--
Teach me to fish! Thanks for the help.
Pax, M


"Landor" wrote:

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

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

"Landor" wrote in message
...
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

"m stroup" wrote:

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.
--
Teach me to fish! Thanks for the help.
Pax, M


"Landor" wrote:

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

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

"Jeff Boyce" wrote:

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

"Landor" wrote in message
...
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

"m stroup" wrote:

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.
--
Teach me to fish! Thanks for the help.
Pax, M


"Landor" wrote:

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

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




"Landor" wrote in message
...
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

"Jeff Boyce" wrote:

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

"Landor" wrote in message
...
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

"m stroup" wrote:

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.
--
Teach me to fish! Thanks for the help.
Pax, M


"Landor" wrote:

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