How can I accumlate a values in a field

S

Savanah

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
 
M

[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
[email protected]
www.fmsinc.com/consulting
 
S

Savanah

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
 
Top