Recent content by kulunggoy

i create a relationship which is the left table is "item" then the right is "withdraw" then i select "item" field as a matching relationship. i create a query and i put all the fields from my "withdraw and item" table. Is it right? Then i dont know where do i put the code you gave to me.. do i...

ok ill try it.. then ill send it to you .. thanks! whats your email?

thanks again for the reply.. i found a solution but it was not satisfying, i tried crosstab in query.. I want to try yours.. can you send me some basic sample? thanks again very much!!!!:o

h t t p://i97.photobucket.com/albums/l223/kulunggoy/db1-3.png.. here's the illustration of what i want to do

for example: in "table 1" i have a 2 fields which is "item, withdraw" then under my "item" field i have a 2 same data "kulangot" the "withdraw" data of the first "kulangot" is "2" and the other one is "3". then another 2 same data in "item" field called "tae" which have "5" and "2" data in...

im using ms access 2003, i want to get the sum of a certain field which there is a condition that it will only sum up the field table1 which have the same word or text.. then the total will be output in the next table2.. please help..sorry if i cant explain it much clearer i can send you the...