If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Is there an easy way?
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Is there an easy way?
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 |
#5
|
|||
|
|||
Is there an easy way?
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 |
#6
|
|||
|
|||
Is there an easy way?
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 |
Thread Tools | |
Display Modes | |
|
|