Search results

yes. that is the calculation. the data type of the fields are in text, then I change it to numeric and got the right answer..

thank you sir.. i tried to change the data type of the field to number and I already get the sum..

why do when i use addition in queries: example: i want the sum of there 3 fields. 1(as record in field1) + 1(as record in field 2) + 1(as record in field 3) the sum gives me 111 instead of 3.. what should i do?

Thanks for your reply Mr.B but I can't fully understand your instruction. Can you give me a step by step process? Well here's the scenario: Student Table Student_Number Field (I set this one as Primary key) Student_Name ex. 09-30170 John Cruz 09-30171 Joanna Lee I want to link these...

hello guys.. i would like to ask that it is possible to link a record from a table to another table? example, in table "Student" with data fields of "Student Number" and "StudentName". in the "Student" table with the record of 09-30170(student number), John Cruz(Student name) and...