Is there an easy way?

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" <Landor.DeleteThis@discussions.microsoft.com> wrote in message
news:90F5AC16-8A04-4190-A202-E8777A1B75E1@microsoft.com...
> 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" <Landor.TakeThisOut@discussions.microsoft.com> wrote in message
> news:90F5AC16-8A04-4190-A202-E8777A1B75E1@microsoft.com...
> > 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" <Landor DeleteThis @discussions.microsoft.com> wrote in message
news:EC2C1D8A-0F9B-45A4-AD59-CD9AB6EA637E@microsoft.com...
> 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" <Landor DeleteThis @discussions.microsoft.com> wrote in message
>> news:90F5AC16-8A04-4190-A202-E8777A1B75E1@microsoft.com...
>> > 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
>>
>>
>>