Search results

  1. T

    Adding A Sum Column

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

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

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

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

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

    Adding A Sum Column

    oh the design view? sure
  7. T

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

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

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

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

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

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

    Creating a Sum

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

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

    Linking

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

    Creating a Sum

    all of my rows have a value for number 1, number 2, and number 3 and these values are able to change i'm trying to figure out a command that adds it up somehow and i dont believe using the + sign like that works
  17. T

    Linking

    i'm just wondering if you would be able to explain your thought process and what the program does because I was told to start access programming 2 days ago and didn't want to just add whatever without knowing what it does thanks for your time
  18. T

    Linking

    sure thing paul i actually made a mock db which is similar to what im working on let me show you this For each item i add in table 1, I want it to link with all the table 2 items For table 2, the user of the program will be inputting values for the 0 to 5 section (one number per row...
  19. T

    Linking

    oh sorry it's not for that reason it's not allowed for me to do that at my workplace i know it'd be a lot easier but im just in a bad position right now really sorry, but i can provide most of the info you need
  20. T

    Linking

    Hmm... Unfortunately I dont think it's allowed for me to post the db on the site. However, i'm wondering if you'd be able to explain how i should be going about this problem i'm having if i think of it in your way table 1 has a list of items and 4 columns (first 3 should be calculated in...
Top Bottom