Learner-am lost

[John]

A friends social club wants to run a sweepstake on the
local Rugby competition. There are 13 games per week [per
round ]. I have 13 queries which run, referencing the
result form.All works but now im lost as to where to go
next. I have been working on then running another
13 "MakeTble" queries and then running another 13 "Append"
queries to award 2 points.So now I have 13 individual
tables with the correct Pts per Name.Combine the 13 tables
in another Query and then produce a report.Phew.
Is this the right track.

Thanks in advance.

John

 

[John]

Sorry about the explanation. I have individual tbls. In my
selection Tbl I have
GameID
Name
Round
Game1
Game2
" "
Game13

All rounds are entered at the begining of the competition.
ie 9 rounds.
Results are recorded in the result tbl. What I can't get
right is changing a selection of H into points. I was QBF
to compare the selection to the results, and thengetting a
total for the round for each person.

John

 

[John Vinson]

Sorry about the explanation. I have individual tbls. In my
selection Tbl I have
GameID
Name
Round
Game1
Game2
" "
Game13

"Fields are expensive, records are cheap". This is a Spreadsheet, not
a relational table. And if you have multiple "individual tbls" like
this, you're not only storing data (game numbers) in fieldnames,
you're storing data in table names too.

All rounds are entered at the begining of the competition.
ie 9 rounds.
Results are recorded in the result tbl. What I can't get
right is changing a selection of H into points. I was QBF
to compare the selection to the results, and thengetting a
total for the round for each person.

It will be very, very difficult to do so with your current table
design. A normalized table design will make it much easier. If you
insist on using this current table structure, then I'm afraid I can't
help you.