Suming Records

[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

 

[Lord Kelvan]

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

 

[Anthony]

Would it look like something like this?

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

 

[John Spencer]

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

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

 

[Lord Kelvan]

o yes sorry forgot the group by