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:
but i got easily 40 fields to perform this. so i tot it will be good if there is another turnaround