Recent

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

Nicole

  • Hero Member
  • *****
  • Posts: 970
[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

rvk

  • Hero Member
  • *****
  • Posts: 6111
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

Nicole

  • Hero Member
  • *****
  • Posts: 970
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.

 

TinyPortal © 2005-2018