> Hello. I'm trying to summarize some numeric data based on its location
> relative to a label field. I have a set of surveys. For each survey there
[quoted text clipped - 29 lines]
> 7.4 99.13
> RBPIN 7.91 99.1
Yes - this is currently an Excel spreadsheet that is being put into a
database. I'd like my Access database to be able to store the raw data
(which it does) and perform needed calc's on command. The question is - how
to write the calcs.
The changes in the label field are the heart of the problem. If the label
field were binary (include/exclude) I could just tell it to sum all the
included values. Instead I have a start label (LBF) and a stop label (RBF)
and some other labels, including blanks, in between.
Thanks for helping me clarify the question Karl. Is this the wrong group
for this topic?
> From your comments and the data display it seems like this is an Excel file
> you are talking about. If so this is Access database newsgroup.
[quoted text clipped - 35 lines]
> > 7.4 99.13
> > RBPIN 7.91 99.1
KARL DEWEY - 24 Oct 2005 20:50 GMT
Access needs all records to be labeled to perform the calculations correctly.
It needs to check the label of each recod to include the value in the sum or
to exclude the value.
I think you best use Excel to do this one.
> Yes - this is currently an Excel spreadsheet that is being put into a
> database. I'd like my Access database to be able to store the raw data
[quoted text clipped - 48 lines]
> > > 7.4 99.13
> > > RBPIN 7.91 99.1
Alaska Hydro - 26 Oct 2005 19:38 GMT
It seems like I should be able to use something like the Seek method to set
temporary variables for the start and end row - then have a loop that sums
the values in between. This would eliminate the need for the program to have
to search for each record based on a label... I think.
> Access needs all records to be labeled to perform the calculations correctly.
> It needs to check the label of each recod to include the value in the sum or
[quoted text clipped - 54 lines]
> > > > 7.4 99.13
> > > > RBPIN 7.91 99.1