Suming Records

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

I have a table and it has numbers in the one item and I would like it to add
the them together and show my there name in the table.

Thanks, Anthony
 
you woudl just use a query you dont add calculated information to
tables

a query like

select itemname, sum(itemvalue) as itemtotal
from itemtable

Regards
Kelvan
 
Would it look like something like this?

select [eventdetail].EmployeeName, sum([copy of event].o_level) as itemtotal
from [copy of event].o_level
 
Pardon me, but it would look more like the following.

SELECT [eventdetail].EmployeeName
, SUM([eventdetail].o_level) as itemtotal
FROM [eventdetail]
GROUP BY [eventdetail].EmployeeName

Note the addition of the GROUP BY clause and the removal of the field name
from the FROM clause.

Also you had two table names in the query - [eventdetail] and [copy of event].
I assumed that you needed only the EventDetail table.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Would it look like something like this?

select [eventdetail].EmployeeName, sum([copy of event].o_level) as itemtotal
from [copy of event].o_level


Lord Kelvan said:
you woudl just use a query you dont add calculated information to
tables

a query like

select itemname, sum(itemvalue) as itemtotal
from itemtable

Regards
Kelvan
Click to expand...
Click to expand...
 
Back
Top