Working Out An Average

[Dannyboy11]

I will not be manually adding any referees. They will all be imported via an Excel spreadsheet that is sent to me monthly.

So a form will then display each referees info. and I can put a subform into this where I can enter in their mark?

I'm going to do what I believe the table structure should be normalised and then if I upload it would you mind taking a quick check?

 

[Kryst51]

I will not be manually adding any referees. They will all be imported via an Excel spreadsheet that is sent to me monthly.

So a form will then display each referees info. and I can put a subform into this where I can enter in their mark?

I'm going to do what I believe the table structure should be normalised and then if I upload it would you mind taking a quick check?

Are you importing the marks too?

 

[Dannyboy11]

Are you importing the marks too?

No. I will receive each referees marks once a week (each referee gets two for one game... home team and away team). However, experience has told me that some teams forget and some referees are left with blanks for marks - would this be a problem? If it would, I'd award them the same as their counterpart and if both failed then I'd give them 75 [what's expected])

 

[Dannyboy11]

Would you say that these tables now provide solid foundations?

Edit: I've just realised that I haven't set the fks to be relationships with the pks. Is this what needs to be done?

Edit: Edit: How can I set a relationship up between the tblAddresses and tblReferees between both RefereeID in each and AddressID in each?

 

[Kryst51]

No. I will receive each referees marks once a week (each referee gets two for one game... home team and away team). However, experience has told me that some teams forget and some referees are left with blanks for marks - would this be a problem? If it would, I'd award them the same as their counterpart and if both failed then I'd give them 75 [what's expected])

OK, You don't have to add referees via your form, but you can use a form tied to your referee table to create the starting point for entering marks. See attached.

 

[Dannyboy11]

With what you've attached, it does look good. However when I try to add extra marks it doesn't add them?

With regards to my attachment, is that normalised? I am unsure of how the relationships should work too :/

I'm sorry if I am appearing to be stupid but I'm a novice with Access but I'd like to get a lot better

 

[Kryst51]

With what you've attached, it does look good. However when I try to add extra marks it doesn't add them?

With regards to my attachment, is that normalised? I am unsure of how the relationships should work too :/

I'm sorry if I am appearing to be stupid but I'm a novice with Access but I'd like to get a lot better

Sorry, some errors, corrected atached.

 

[Dannyboy11]

Hi

I was trying to transfer your form over to the database that I have been editing (normalisation) and I think I've broke it.

Basically, I tried to make it so the drop down only showed referees who were 'Yes' for 'Registered with 9v9' and now it comes up with a parameter value and also the average calculator at the bottom only worked for the first referee but not for any after.

Is it possible you could tell me where I have gone wrong?

 

[Kryst51]

Hi

I was trying to transfer your form over to the database that I have been editing (normalisation) and I think I've broke it.

Basically, I tried to make it so the drop down only showed referees who were 'Yes' for 'Registered with 9v9' and now it comes up with a parameter value and also the average calculator at the bottom only worked for the first referee but not for any after.

OK.... You NEED to learn what this stuff is doing..... Hence you need to read up on forms, form controls etc.... The combo box is pulling names from a query... so you don't need to change the form source, that will ruin everything... What you need to do is modify the query (not change) that the combo box is pulling from. The query you were modifying is the query that is pulling your average, and had nothing to do with modifying the names that show up in your combo box.

Also, you have no relationships set up in the relationship screen, you need those, it will make life easier on you.

Try this on for size. - Edit: I also wanted to remark, keep it up..... just read up on some of this stuff if you aren't understanding. You'll get it.