Calculation Problem

From: NeWuSeR (koningsander_at_tvvbf.nl)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 01:55:46 +0100

Hi all,

I'm facing the next problem.
When running a query

ADOQuery5.Active := False;
ADOQuery5.SQL.Clear;
ADOQuery5.SQL.Add('SELECT SUM(Artikelregels.M2) AS SomVanM2');
ADOQuery5.SQL.Add('FROM Artikelregels');
ADOQuery5.SQL.Add('GROUP BY Artikelregels.Referentienummer');
ADOQuery5.SQL.Add('HAVING (((Artikelregels.Referentienummer) =' +
Label25.Caption + '))');
ADOQuery5.Active := True;

I'm running this query after posting a value M2 in the Table Artikelregels.
If there's one value posted the sum is correct.

When posting the second value M2 and running the query again the sum stays
the same
but after posting the third value M2, the sum is correct!

I'm running this with an MSAccess Database.
Has anyone ever faced this strange problem?

Relevant Pages

  • Re: Struts - Getter method
    ... group loves source code, as a rule. ... posting the code then. ... but it's not a collection of type Book. ... Query, while creating ...
    (comp.lang.java.programmer)
  • Re: Struts - Getter method
    ... group loves source code, as a rule. ... posting the code then. ... Query, while creating ... instances of type Book and setting the attributes of each instance ...
    (comp.lang.java.programmer)
  • Re: no responses...
    ... so again your posting hasn't gone astray. ... I was in frequent touch for all the excel help i needed untill now, ... "Kicking Out" Inactive Users / Help!!! ... I did also send a query on knowing how to scroll a message in a text box ...
    (microsoft.public.excel.misc)
  • Re: WH_JOURNALRECORD not working correctly.
    ... Hello and thank you very much for looking at my query. ... After a lot of messing around and posting to this newsgroup I have found out ... software on the origional PC and now the hook functions correctly. ... You can send feedback directly to my manager at: ...
    (microsoft.public.win32.programmer.ui)
  • Re: Calculation Problem
    ... <SNIP> ... > I'm running this query after posting a value M2 in the Table ... > If there's one value posted the sum is correct. ...
    (alt.comp.lang.borland-delphi)