Recent

« previous next »
Pages: 1 [2]

Author Topic: Firebird 4 - "SUM" with where clause  (Read 860 times)

Nicole

  • Hero Member
  • *****
  • Posts: 745
[solved] Re: Firebird 4 - "SUM" with where clause
« Reply #15 on: March 24, 2023, 07:32:08 pm »
this figures exactly what I want.
Thank you so much, you are my hero
Logged

rvk

  • Hero Member
  • *****
  • Posts: 5192
Re: Firebird 4 - "SUM" with where clause
« Reply #16 on: March 24, 2023, 07:51:49 pm »
BTW This also counts the amounts of records before the Entry_Date in the sum().
If that's not wanted you also need to include that one in the where of the sub select
Logged

Nicole

  • Hero Member
  • *****
  • Posts: 745
Re: Firebird 4 - "SUM" with where clause
« Reply #17 on: March 25, 2023, 06:34:27 pm »
this is an extremely useful feature, not a bug.

But I spoiled something.
If you have time, it would be great, if you can read my very last posting.
Logged
Pages: 1 [2]
« previous next »
 

TinyPortal © 2005-2018