how can i have authomatics calculation in access like in Excell

F

Filipe Kanga

Gents,

i nee a Help how can create authomatics calculation in Access2003 database
as we often do in excell
 
W

Wayne-I-M

Hi Filipe

There is a major difference between the way calculated results are handled
in Access and Excel. In access calculated results are "not" normally stored
but in Excel they are.

As an example. If you have 2 apples and 2 oranges in Excel you would stored
the result (sum of fruit) but in Access you don't. You would simply perform
the calculation and use the result as and when you need it. So you could
display in a query, form or report that you have 4 items of fruit but this
calculated result would not be stored. The reason for this is that if you
add and apple to the shop or store your calculation would (if you had stored
it) be now wrong (as you now have 5 items of fruit).

There are too many methods of calculations to put here - basically you can
do most things in Access that you can do with Exccel BUT Access is a database
not a preadsheet so there are major differences.
But in excel 1 + 2 will always = 2
In Access 1 and 2 will be the name of a field and the sum result of a
calculation will be the sum total of the contents stored in the the field.
So if field 1 is a field containing the number of apples and field 2 is a
field containing the number of oranges then 1 + 2 = the sum total of all the
fruit in the fields.


If you create a database and have specific question about how to do a
particular calculation you can ost it here and someone may answer. But it's
not possible to answer a question like "how do I do a calculation in Acess"

Hope this helps - but I understand it's a little confusing at 1st.
 
K

KoldKay

As you have already been informed, Access is not, nor should be, a
spreadsheet. Maybe if you could tell us exactly what and way you need we
can be of some help. As you may have guessed, chances are you don't need to
do what you asked for as in Access you likely will want to do something
different.

Consider it like this. If you have driven a car with manual
transmission all your life and then you get a car with automatic, you want
to learn to drive an automatic, not force the automatic to act like a
manual.
Click to expand...

You can however use Expressions in queries. Do this as such: Select
the table you want from a query, then where it says Field: go to a
blank section and type something like this: "Total: [dbo.tablename].
[Fieldname] + [dbo.tablename2].[Fieldname2]"

Then that will add the two values in that record together, under the
Total field.

This might be what you're looking for.
 
Top