Subject Re: how to calculate 2 records of the same column of a grid : solved
From Dirk <>
Date Wed, 13 Jan 2021 11:27:14 +0100
Newsgroups dbase.getting-started

Op 12/01/2021 om 21:00 schreef Dirk:
> Goodday,
> i am trying to calculate 2 records of the same  column as excel, make a
> sum in a calculated fields, by clicking on the grid cell
> means want to know the consume of solar electricty in a certain period
> i can of course use 2 colums , 2  fields : 1 begin and 1 end
> but begin of column 1 day x, should be end of column end day - 15
> day is date field i put the info into
> so, to avoid a column i trying to find out a way as excel
> thanks for a helping hand
> best regards
> Dirk

  Good -moring,day,evening sirs

   thanks for your usefull replies
  as mentioned = using id and date field ( will use this to have the
know    the consumption for a periode of a month or year

  to quote on a weekly or daily base i composed the following

    Function verbruik
         local Bereken, nWaardeA, nWaardeB
            Bereken =Form.Vraagbak_DataEnergie.rowset
                   nWaardeA = (Bereken.fields["eDageinde"].value)
            nWaardeB= (Bereken.fields["eDageinde"].value)
         form.veld_totverbruik.value =(( nwaardeA) -(nWaardeB))                

   your examples widen my horizon again

   take care