Sorry my mistake trn.year is decimal. I can not change it. Is it not possible to filter the year in Case statement?

Hi Phil,

TrnDate datatype is decimal and length 5. I tried your suggestion but I should not get any data from 2022 because there isn't any but the query brings the...

Hi Phil,

It didn't work. I tried as you suggested but I get the result even though there is no data in TrnYear=2022 but the query bring all the data from...

Thanks, Phil for kind words. In my query I have been trying to filter following options but I know the query does not filter when I use a.TRNyear=2022 or 2020....

Thanks, Michael.

I have created a query but not filtering properly. for example and I like to show it on the report where I have struggles it so far.

            
November 22, 2021 at 4:57 pm
            
#3955727

            
            
                                                
        

Thanks, John and Michael. It worked after Grouping the account number.

Hi John,

I have tried the same solution as yours but it brings every date of transaction against the account.

I hope it helps.
+---------------------------------------+
|      Results      |
+---------------------------------------+
| 12/03/2018 | 25 | Carriage | | | |
+------------+------+----------+--+--+--+
| 12/03/2018 | 25 | Carriage | ...

I am trying to figure out how I could get the desired result.  If I have got 1552 qtyinstock and there is an order for 1550. It should minus the...

Apologies Thom, Please see attached file.

Hey Thom, 

I seem to use your idea on my query but the balance but I have failed to acheive the desired result for example
If I have got...

Thanks it gives me ideas to manipulate for few days.

I have added the due date column.

CREATE TABLE mytable(
 DueDate    DATE NOT NULL
,ProductName   VARCHAR(5) NOT NULL
,ProductDescription VARCHAR(18) NOT NULL
...

Good question. I may be able to  add order by due date and minus from the date order?

Sorry for the confusion. Here is my best effort

| | A | ...