how do I create a footbool league table in Access 2003

[Guest]

 

[John Vinson]

On Tue, 19 Sep 2006 14:57:02 -0700, Gilbo

Same way you create any table. Identify the Entity Type that the table
represents (real-life persons, things, or events); identify the
Attributes of each entity (the information that you need to know about
the entity); create the table, add the attributes as fields.

If you have a specific problem (other than "please create my
application for me") please post back, we'll be glad to try to help.


John W. Vinson[MVP]

 

[Guest]

I have now created my league table with columns as follows:-
Played, Won, Draw, Lost, Goals For, Goals Ag, Diff. My problem now is that
in the won, draw and lost column if a team has not got an entry the query
shows a blank and I want it to show a "0"

 

[John Vinson]

I have now created my league table with columns as follows:-
Played, Won, Draw, Lost, Goals For, Goals Ag, Diff. My problem now is that
in the won, draw and lost column if a team has not got an entry the query

I hope you have fields to identify the team!?

All of these fields are derived fields, if you store the scores of the
game.

To solve your zero problem, use a calculated field:

ShowWon: NZ([Won])

This will show the value in Won if there is one (won?); if the field
is null it will show a zero.

Alternatively, set the Default property of each of these fields to 0.

John W. Vinson[MVP]

 

[Guest]

Thanks for your help - everything is now working ok - but I would now like to
add a position (1 - 12) as another column that always appears in the correct
order (1 - 12). There are 12 teams in my league.

I have now created my league table with columns as follows:-
Played, Won, Draw, Lost, Goals For, Goals Ag, Diff. My problem now is that
in the won, draw and lost column if a team has not got an entry the query

I hope you have fields to identify the team!?

All of these fields are derived fields, if you store the scores of the
game.

To solve your zero problem, use a calculated field:

ShowWon: NZ([Won])

This will show the value in Won if there is one (won?); if the field
is null it will show a zero.

Alternatively, set the Default property of each of these fields to 0.

John W. Vinson[MVP]

 

[John Vinson]

Thanks for your help - everything is now working ok - but I would now like to
add a position (1 - 12) as another column that always appears in the correct
order (1 - 12). There are 12 teams in my league.

Don't worry about the TABLE being in order. Tables are just unordered
buckets of data.

Add an Integer number field to your table, enter the numbers, and use
a Query sorting by that number as the basis of your combo box, form,
report, etc.

John W. Vinson[MVP]

 

[Guest]

Thanks again for your help

Don't worry about the TABLE being in order. Tables are just unordered
buckets of data.

Add an Integer number field to your table, enter the numbers, and use
a Query sorting by that number as the basis of your combo box, form,
report, etc.

John W. Vinson[MVP]