Using formulas in Access??

E

Erik

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,
 
J

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>
 
E

Erik

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?
 
J

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?
Click to expand...

Yes.

John W. Vinson[MVP]
 
Top