How can I accumlate a values in a field

[Guest]

I have a table like
week id week sig sf drop rand
1 1 4 2 1 1
2 2 new#plus anterior number

II need to accumulate for every details the anterior numebr plus new number
and show in a linear chart, I had the chart ok, but I can make a query to
accumulate
values, actually I used count or sum but did not work, Tia

 

[[MVP] S.Clark]

Your table is really a crosstab, and not a normalized table. This can be
very problematic when trying to use Access queries.

I must admit, that I don't understand what you mean by 'Anterior' number and
'New' Number, so feel free to explain more, or give an exact example.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Guest]

Steve,
for example
on wee 1 i have 4 signed 2 sf and 1 drop and 1 rand
on week 2 will be whatever number I am entering plus that one I had before,
if I am entering 3 signed I will have 7 (4+3) but I want to show in linear
chart. Tia