forms in access

[vvcano]

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

 

[Damian S]

Calculate what? How about:

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

Damian.

 

[John Vinson]

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]

 

[vvcano]

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.

 

[vvcano]

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

Calculate what? How about:

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

Damian.

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

 

[John Vinson]

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]

 

[John Vinson]

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]

 

[vvcano]

see below

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.

 

[John Vinson]

see below


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.

<shrug>

I'll try to help you - *if* you'll cooperate.

I'll check back in this thread and see if you've answered the very
clear questions. If not, obviously I won't be able to help.

Right now all I can suggest is "There is an error in your expression
or the control source of this textbox. Fix that error and you'll be
fine."

John W. Vinson[MVP]

 

[Jeff Boyce]

Is there a chance your "Grand Total" control on the form is unbound? If it
were, when you shift from one record to the next I'd expect the "old grand
total" to still show. That sounds a bit like a "running sum".

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

see below


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.

however each section on the form needs it's own daily total. should i do a
sub form?

 

[missinglinq via AccessMonster.com]

I think John's question

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

is the most important here. Which is it?