C Cheryl Oct 7, 2003 #1 Howdy, school teacher in need. How do I input a SUM function to add up data in a record?
L Lynn Trapp Oct 7, 2003 #2 Do you want the total of various fields in a single record? If so, then just use simple math: CalculatedValue: Field1 + Field2 + Field3....... However, if you want the total of a column then use the Sum() function: Sum(Field1)
Do you want the total of various fields in a single record? If so, then just use simple math: CalculatedValue: Field1 + Field2 + Field3....... However, if you want the total of a column then use the Sum() function: Sum(Field1)
C Cheryl Oct 8, 2003 #3 Thanks for your response but where do I put this command, in the field where calculated amount should appear or do I have to create a macro?
Thanks for your response but where do I put this command, in the field where calculated amount should appear or do I have to create a macro?
L Lynn Trapp Oct 8, 2003 #4 place it in a blank field in the query grid. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm
place it in a blank field in the query grid. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm
