C Chris Jul 28, 2003 #1 Is there any way to total columns in an access query without analyzing it with excel? Thank you
R Rick Brandt Jul 28, 2003 #2 Chris said: Is there any way to total columns in an access query without analyzing it with excel? Click to expand... Add a calculated field to the query. TotalCol: Field1 + Field2 + Field3
Chris said: Is there any way to total columns in an access query without analyzing it with excel? Click to expand... Add a calculated field to the query. TotalCol: Field1 + Field2 + Field3
G Guest Jul 29, 2003 #3 Joe, thanks- exactly what i needed! CM -----Original Message----- Chris said: Is there any way to total columns in an access query without analyzing it with excel? Click to expand... No and yes. In the query itself, no; but it's a simple matter to create a report based on the query and gereate the sums in the report footer. Insert a text box in the footer & set the data source to =Sum ([FieldName]). Joe F. . Click to expand...
Joe, thanks- exactly what i needed! CM -----Original Message----- Chris said: Is there any way to total columns in an access query without analyzing it with excel? Click to expand... No and yes. In the query itself, no; but it's a simple matter to create a report based on the query and gereate the sums in the report footer. Insert a text box in the footer & set the data source to =Sum ([FieldName]). Joe F. . Click to expand...
