If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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] |
#12
|
|||
|
|||
forms in access
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] |
#13
|
|||
|
|||
forms in access
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 |
|
Thread Tools | |
Display Modes | |
|
|