forms in access

On Mon, 4 Dec 2006 21:53:02 -0800, vvcano
wrote:

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.

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]

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
http://mvp.support.microsoft.com/

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

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


"vvcano" wrote in message
...
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]

I think John's question

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

is the most important here. Which is it?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com