# Recent content by torontoguy

1. ### Adding A Sum Column

alright i'm gonna think about this for the weekend and let you guys know how its going thanks
2. ### Adding A Sum Column

ah alright thanks btw, is there a way to sum only a certain amount of records at a time? eg. Item # Dim Value Sum 1 Cost 1 7 1 Production 4 7 1 Repair...
3. ### Adding A Sum Column

hmm what i was getting from your code was the same number as the TotalItemValue per row more like: [Item Number], Dimensions, Zero, One, Two, Three, Four, TotalItemValue, GrandTotal 1234,abc,100,200,300,400,1000,1000 1235,def,101,201,301,401,1001,1001
4. ### Adding A Sum Column

Yes I am trying to find the grand total of all the TotalItemValue numbers. However, when I changed my SQL stuff with what was given, it seems to have made another COLUMN named "Grand Total" after TotalItemValue and this is something that just equals the same number as the TotalItemValue. Any...
5. ### Adding A Sum Column

here you are: SELECT [Mock Value].[Item Number], [Mock Value].Dimensions, [Mock Value].Zero, [Mock Value].One, [Mock Value].Two, [Mock Value].Three, [Mock Value].Four, Sum([Zero]+[One]+[Two]+[Three]+[Four]) AS TotalItemValue FROM [Mock Value] GROUP BY [Mock Value].[Item Number], [Mock...
6. ### Adding A Sum Column

oh the design view? sure
7. ### Adding A Sum Column

I just created a query with a column to be the sum of 5 different columns My question is: Can I create a "TOTAL" for the column "TotalItemValue"?
8. ### Creating a Sum

thank you! now to edit the looks i've got other questions about access which i'll be getting to shortly thanks very much for the help on this topic :)
9. ### Creating a Sum

that's my little problem i cant seem to figure out how to make the form use the query form: query: in post #9 posted @ 10:00 AM
10. ### Your help is allowing me to learn access and I'm very grateful of that as I wasn't trained on...

Your help is allowing me to learn access and I'm very grateful of that as I wasn't trained on this at all but was put in the middle of an ongoing project thanks very much for your past help, present help as well as future help
11. ### Creating a Sum

yes sir! alright so i turned "Mock Item" into a form but that only shows the id, item #, item, A, B and C to add the query calculation into the Mock Item form, what would I need to do
12. ### Creating a Sum

okay, it works in the query itself any ideas as to how i can get it to show in this table after C? or can i show it on a form?
13. ### Creating a Sum

i will remember that from now on, thanks a lot is that what you meant?
14. ### Creating a Sum

hmm i see any way you could guide me through creating the query using ms access 2007? let me upload the pic of my query for you I want the Total (A+B+C) to be the total value of values A, B and C