Access 2003 and maths

[Olivier]

Hello,

I have a large Access 2003 database with about 50 000 records upon which I
would like to perform mathematical operations (percentages, weighted
averages, etc). However, I don't know how to perform these operations in a
relatively rapid way. So, I'm using Excel to reach my goal but this solution
is not really adapted to a big quantity of data (I have sometime several tens
of thousands records !). I'm aware that it's not possible to manage math
operation under Access like under Excel.
So, I'm looking for an optimal solution that shall allow me to manage both
the maths operations and the functionalities of a relational database.

Big thank you for your help !

 

[Klatuu]

Where do you want to do this math? In a query, using recordset processing,
or in a form module?
If you review VBA Help, you will find a rich asortment of math operations.
They are no harder to manage than in Excel.

If you can describe where you want to do the math and what you want to do,
perhaps we can help with the how.

 

[Jerry Whittle]

Create a simple query with a few of your number fields. Next go up to View,
Totals. Notice that it adds a Total row in the grid. Click on Group By and
select the drop down that appears. Play with some of the items there. NOTE:
First and Last are useless UNLESS you sort by an appropriate field. Min and
Max usually work better.

 

[Olivier]

Hello Klatuu and Jerry,

In fact, my problem was trivial. I was not aware of some Access possibilities.
Thank you for your answer !