Mathematical Calculations

[SiH23]

I would be most grateful if someone could help.

I have a spreadsheet that I wish to import into Access. Is is possible to
carry out Sum, Average and Count functions in an Access database? If so,
please could someone give me a step by step guide on how to set this up.

Many thanks in advance.

Simon.

 

[Douglas J. Steele]

The generic term for what you want is "Totals query".

Create a query and add the fields on which you want the calculations done.
If you want three separate calculations done on a single field, you'll need
to add the field to the grid three times.

Change the query to a Totals query (in Access 2003 and earlier, this is done
through the View menu when the query is in design view). That will add a new
Total row to the grid, with all cells set to Group By. Under the fields
where you want the calculations, change Group By to the appropriate
function.

 

[John W. Vinson]

I would be most grateful if someone could help.

I have a spreadsheet that I wish to import into Access. Is is possible to
carry out Sum, Average and Count functions in an Access database? If so,
please could someone give me a step by step guide on how to set this up.

Many thanks in advance.

Simon.

You cannot (and need not, and should not) do such calculations in a Table. A
table may look like a spreadsheet, but it isn't!

Instead store the "real" base data in a Table, and use Queries to do the
calculations.

We can't give you step by step instructions for how to do something, though,
unless you describe what you're starting with and what you want to do. It will
involve creating a Query and clicking the Greek Sigma icon to make it a Totals
query, but without a more specific question it's hard to give a more specific
answer!