Formulas

[Brandi]

Hi, I was wondering if anyone could give me some insight on the average
formula in Access 2007.

I'm trying to set-up some sort of database for the company I work for and
I'm having trouble with one part of the set-up. I need to create something to
figure an average cost of prices that are set up in their own columns. I have
already imported data from Excel 2007 into a table in Access and I'm not too
familiar with using formulas and such in Access. Can you even use them? If
so, in which part of Access do they apply (tables, forms, queries, etc..).
And if you can use this average formula, how do you set it up?

Please help!

Thanks.

 

[BruceM]

In a form or report an unbound text box could have the Control Source:
=Avg([SomeField])
In Access this is known as an expression. It uses the Avg function. An
average can also be calculated in a query, or in VBA (code).
However, the question goes well beyond how to write the expression. In
order to apply the expression effectively you need a properly designed
database structure. Access is a program for building a relational database
application. In order to do that you need to understand how a relational
database works, and how it differs from a spreadsheet such as Excel. That
discussion is beyond the scope of a newsgroup posting, but there are
resources available. This tutorial is a good place to start:
http://allenbrowne.com/casu-22.html
There are other articles available here, especially in Tips for Casual
Users:
http://allenbrowne.com/tips.html
This page contains links to other resources:
http://allenbrowne.com/links.html
There are many resources other than Allen Browne's web site. One of those
is:
http://www.mvps.org/access/
I often reference Allen's site because it contains a wide range of
information and links all in one place, but many others have resources for
users at all levels. You will find them as you explore.