forms in access

how do i calculate in a form without creating a running sum?

Calculate what? How about:

=[field1] + [field2] + [field3]

Damian.

"vvcano" wrote:

how do i calculate in a form without creating a running sum?

On Mon, 4 Dec 2006 20:10:00 -0800, vvcano
wrote:

how do i calculate in a form without creating a running sum?

Depends on what you want to calculate, and on what's in your tables.

We don't know. Care to give us a hand?

John W. Vinson[MVP]

i'm entering data into my forms. one field is going to have a grand total.
however the grand total should be different for every form "entry". does
this make sense?
i have put in the formula that i want however on the next form it gives me
the total for the previous form.

"John Vinson" wrote:

On Mon, 4 Dec 2006 20:10:00 -0800, vvcano
wrote:

how do i calculate in a form without creating a running sum?

Depends on what you want to calculate, and on what's in your tables.

We don't know. Care to give us a hand?

John W. Vinson[MVP]

i did that. i just don't want it to give me a running total in the next form
entry.

"Damian S" wrote:

Calculate what? How about:

=[field1] + [field2] + [field3]

Damian.

"vvcano" wrote:

how do i calculate in a form without creating a running sum?

On Mon, 4 Dec 2006 20:39:00 -0800, vvcano
wrote:

i'm entering data into my forms. one field is going to have a grand total.
however the grand total should be different for every form "entry". does
this make sense?

Not to me. Sorry. A grand total is - to me - a total over several
records (and should not be stored in any table). A different grand
total for every entry makes no sense!

i have put in the formula that i want however on the next form it gives me
the total for the previous form.

"The next form"? "The previous form"?

Are you opening different Access Form objects? Or are you using the
word "form" to mean something else? How are you doing the calculation?
You say "one field is going to have a grand total" - a total of WHAT?

Please explain the real-life problem you're trying to solve, and
describe the structure of your tables and your form. Remember we
cannot see your screen and cannot read your mind - we don't KNOW what
you're seeing, or what you're trying to do.

John W. Vinson[MVP]

i'm sorry if this is confusing.
i'm trying to prevent a running sum in a calculated field. i don't want
this sum to be added to the next entry i make in the form.

"John Vinson" wrote:

On Mon, 4 Dec 2006 20:39:00 -0800, vvcano
wrote:

i'm entering data into my forms. one field is going to have a grand total.
however the grand total should be different for every form "entry". does
this make sense?

Not to me. Sorry. A grand total is - to me - a total over several
records (and should not be stored in any table). A different grand
total for every entry makes no sense!

i have put in the formula that i want however on the next form it gives me
the total for the previous form.

"The next form"? "The previous form"?

Are you opening different Access Form objects? Or are you using the
word "form" to mean something else? How are you doing the calculation?
You say "one field is going to have a grand total" - a total of WHAT?

Please explain the real-life problem you're trying to solve, and
describe the structure of your tables and your form. Remember we
cannot see your screen and cannot read your mind - we don't KNOW what
you're seeing, or what you're trying to do.

John W. Vinson[MVP]

On Mon, 4 Dec 2006 21:20:01 -0800, vvcano
wrote:

i'm sorry if this is confusing.
i'm trying to prevent a running sum in a calculated field. i don't want
this sum to be added to the next entry i make in the form.


It's rather difficult to CREATE a running sum in an Access form. It
certainly does NOT build running sums on its own.

Please answer these questions:

1. What is the Recordsource of your form? If it's a table, describe
the fields. If it's a Query, please post the SQL view of the Query.

2. What type of Form are you using - Datasheet, Continuous, Single?

3. Does the Form have any VBA code or Macros associated with it? If so
please post the code.

4. What is the Control Source property of the textbox which is giving
you this result?

5. Could you give a REAL LIFE EXAMPLE with REAL LIFE DATA describing
what happens to give you a running sum; and what you would like to
see?

John W. Vinson[MVP]

see below

"John Vinson" wrote:

On Mon, 4 Dec 2006 21:20:01 -0800, vvcano
wrote:

i'm sorry if this is confusing.
i'm trying to prevent a running sum in a calculated field. i don't want
this sum to be added to the next entry i make in the form.


It's rather difficult to CREATE a running sum in an Access form. It
certainly does NOT build running sums on its own.

Please answer these questions:

1. What is the Recordsource of your form? If it's a table, describe
the fields. If it's a Query, please post the SQL view of the Query.
my table consist of number of items, total dollar amount for the states of
AZ, CA, and NV. I work in an operations environment for a bank.

2. What type of Form are you using - Datasheet, Continuous, Single? Single

3. Does the Form have any VBA code or Macros associated with it? If so
please post the code. NO

4. What is the Control Source property of the textbox which is giving
you this result?
A sum? this may be referring to the data that i want added. similar to excel when you are calculating several cells to get a total.
5. Could you give a REAL LIFE EXAMPLE with REAL LIFE DATA describing
what happens to give you a running sum; and what you would like to
see? each entry is entered each day. i enter the numbers(shown above) however each section on the form needs it's own daily total. should i do a sub form?

John W. Vinson[MVP]

"vvcano" wrote in message
...
i did that. i just don't want it to give me a running total in the next form
entry.

It won't. That expression is the sum of three fields in the *current* record.
There is no easy way to make that a running sum even if that is what you wanted.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com