Using formulas in Access??

[Guest]

I am using an Access database to keep track of stats for a Hockey League
which I post on the net using the database. I was wondering if there was any
way to add formulas into the database tables to calculate winning % and total
points? I know its easy to do in Excel but is there any way in Access to
getthe same functionality?

Thank you,

 

[Jeff Boyce]

Erik

A couple possibilities...

1) keep the raw data in Access (assumes you need the searching and
reporting capabilities) and export query results to Excel for
calculations/analysis.
2) keep the raw data in Access and use queries and reports to do the
calculations.

Good luck

Jeff Boyce
<Access MVP>

 

[Joseph Meehan]

I am using an Access database to keep track of stats for a Hockey
League which I post on the net using the database. I was wondering if
there was any way to add formulas into the database tables to
calculate winning % and total points? I know its easy to do in Excel
but is there any way in Access to getthe same functionality?

Thank you,

Sure. Normally you would store just the data in the table and compute
percentages etc. in a query and or report.

You can also store the data in Access and under tools, office links,
analyze with Excel.

 

[Guest]

Right now I'm using an ASP script that reads the database tables and updates
my webapge. Can I do the same thing with the queries?

 

[John Vinson]

Right now I'm using an ASP script that reads the database tables and updates
my webapge. Can I do the same thing with the queries?

Yes.

John W. Vinson[MVP]