Recent content by torontoguy

alright i'm gonna think about this for the weekend and let you guys know how its going thanks

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...

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

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...

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...

oh the design view? sure

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"?

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 :)

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

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

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

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?

i will remember that from now on, thanks a lot is that what you meant?

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

alright thanks i believe you understood what i was trying to do so i'll try this now however, i was wondering what the steps are for going through to make that query? Do i go to query wizard and click simple query? After that, which columns do i select? Thanks Paul (I know it's a little...