By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,561 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Ms Aceess Create Loop Sum Of Cells Between A Column

P: 1
Goodmorning to every body!!!!!
My "problem" for 2day is this:
I have a column in a access database with 50 cells, let us say.
All cells are filled with 1 and 0 quite like these:
1
0
0
1
1
0
0
0
1
what I need to do is to sum the cells of the column 2by2 it's it time, with a loop and to create a new column that would be like this:
1
1
1
2
2
2
2
2
3

thanks in advance!!!!!!!!!!
Dec 5 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
OK firstly, Access doesn't have cells, it has rows of values. In this case we are talking about values stored in one field.

Secondly, I still can't understand what you are asking for. If you are asking about relating the data in one row to the data in another row you can't do this just be referring to the row previous or next as Access doesn't store it this way.

Try to give a fuller explanation of what you are trying to do and why? Also give information about what else is stored in this table particularly and field that may have a unique value.
Dec 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.