Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    3

    Unanswered: Subtract values from multiple queries

    Hi everyone, i have a query. how do i subtract numerical values btw tables?

    pls look at the atatched file. i have 2 tables (Table1 and Table2) with several fields [ABC], [XXX], [YYY] .... in both tables. i need to subtract the values under these but i need to get what is displayed in Query1 showing individual difference (not overall difference - if so i could have combine the fields into one field like "ABCXXXYYYZZZ " to get the value of 38. i could do this in excel and just pivot out the dataset to get the individual difference but its tedious and i want to learn how to do it in access because i foresee i have to do a lot of such multiple tables subtraction so its better i do this in access. if someone could point me to the right direction, i will be very grateful.

    I could do following:

    Diff:[Table1].[XXX]-[Table2].[XXX]

    but i got easily 40 fields to perform this. so i tot it will be good if there is another turnaround

    Thank you for reading!
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Quote Originally Posted by graveyard View Post
    ... but i got easily 40 fields to perform this. so i tot it will be good if there is another turnaround
    There is none that I know.
    Have a nice day!

  3. #3
    Join Date
    May 2011
    Posts
    3
    Quote Originally Posted by Sinndho View Post
    There is none that I know.

    hi sinndho, thanks! guess i will think of other options to work around this

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •