Re: One more ! Calculating Recordset Values

Tech-Archive recommends: Fix windows errors by optimizing your registry

There are 3 recordsets, each containing about 20 numeric values.

I was using the script below to retreive them, it was my attempt at
calculating them.


"p c" <nospam@xxxxxxxxxx> wrote in message
news:k-6dnSenD7Aimu3enZ2dnUVZ_sidnZ2d@xxxxxxxxxxxxxx
> To anser your uestions, can you provide more informaion? How many
> recordsets do you have? What's in each one? How are you retrieving the
> records.
>
> Give an example of what's in each value.
>
> ..PC
>
>
> RobA wrote:
>> Can anyone point me in the direction of some guidance for handling
>> recordset values.
>>
>> I am trying to calculate a resultant value (total) of adding 2 values and
>> mulitplying by the third.
>>
>> Eventually I wanted to get total for the resultant value (all the totals
>> added together) for the whole recordset!
>>
>> <%
>> Dim Total
>> Do While not aScrRst.EOF
>> Do While not eScrRst.EOF
>> Do While not iScrRst.EOF
>> Total = iScrRst("Score") + eScrRst("Score") * aScrRst("Score")
>>
>> Response.Write "Total"
>>
>> aScrRst.MoveNext
>> eScrRst.MoveNext
>> iScrRst.MoveNext
>>
>>
>> Loop
>> Loop
>> Loop
>> %>


.

Relevant Pages

  • Re: How to summarize recordset...Select Distinct alternative?
    ... Totals Summary: ... Your options are limited with Jet. ... Shaped recordsets may be the answer, ... section of your report. ...
    (microsoft.public.data.ado)
  • Re: One more ! Calculating Recordset Values
    ... How many recordsets do you have? ... RobA wrote: ... Eventually I wanted to get total for the resultant value (all the totals added together) for the whole recordset! ...
    (microsoft.public.frontpage.programming)
  • Re: One more ! Calculating Recordset Values
    ... This is the code to I was using to retreive the recordsets. ... UID ... Set aScrRst = objConn.Execute (aSQLstr) ... >> Eventually I wanted to get total for the resultant value (all the totals ...
    (microsoft.public.frontpage.programming)
  • Re: dealing with max number of fields
    ... there is one big technical hurdle to overcome - I have no idea what you ... What is a JET table? ... You could, for example, open multiple recordsets to retrieve the data ... from the JET tables, loop through them, and print the data to a text file. ...
    (microsoft.public.access.externaldata)
  • Re: Halt code execution when closing form
    ... ADO recordsets have a CursorType = adOpenForwardOnly....and fields stay untouched they're only "read", ... For every record in the loop, a call is issued to a function that provides progress field update on the dialog, hence every 1% a doevents is issued enabling textbox update and user input control... ... As it can take some time to perform, it is possible to halt execution, ...
    (microsoft.public.access.formscoding)