PLEASE, PLEASE HELP! THANKS ALLOT (Calculate Tick Boxes?)

[Guest]

I am doing a supporters club booking system for Leeds United, (for school

A2) I have a field with every match, then on the left, the members are
listed, you go across the table and tick the maches for each member.

I need a total amount of games eahc member is goign to (ticked) and a
total
amount of mebembers goign to each match.

HOW IS THIS DONE.

PLEASE, PLEASE HELP! THANKS ALLOT

THANKS SO MUCH!!! THANKS, I APPRECIATE IT

 

[Peter R. Fletcher]

I am doing a supporters club booking system for Leeds United, (for school


THANKS SO MUCH!!! THANKS, I APPRECIATE IT

I am afraid that what you are describing is a spreadsheet, not a
database!

You should (as a minimum) have created a relational table structure,
with a Supporters table, with one record (Fields: SupporterID,
LastName, FirstName, OtherInfo1,....,OtherInfoN) for each supporter
and an Attendances table, with at least three fields
(AttendanceID,Supporter,Match). The ID fields would be AutoNumber
primary keys, and there would be a many to one relational link between
Attendances.Supporter and Supporters.SupporterID. Match could be
simply the match date (assuming only one match per day) or it could
(better) be a link to a Matches table with more information about the
match - date home/away, time, score, etc.

Your data entry form would allow you to create an appropriate record
in Attendances for each supporter/match combination.

If you used this structure, you could answer your questions very
easily:
Question 1 translates into counting all the records in Attendances for
for which Supporter = {ID of specified Supporter}.
Question 2 translates into counting all the records in Attendances for
which Match is {specified Match}.

If you don't get the structure of a database right, everything becomes
much more difficult.

BTW, please don't SHOUT!

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[Guest]

Hello Peter, i got your email. Firstly, THANKS, & sorry for shouting.

I really appreciate your help, I could even email my database to you.

Think I understand what your saying and will try it.

One question, do you think I would be best, trying it in a new database
rather then messing around in my current one, then do it when I have got it
right?

THANKS ALLOT