I am trying to filter data as per the dates selected in form and the data is based from crosstab query
I have attached the db file
kindly suggest.
thanks
Thanks, I have tried like as under
Month(Format([TranDate],"mmm-yyyy"))
But I want the months should have to show as like, mmm-yyyy whereas it's showing month numbers
How to make the monthly sequence sorting order in crosstab query.
I have attached the screen shots of the query.
The criteria which have been used for the query is as under;
TRANSFORM Sum(Stock_In_Out) AS SumOfStock_In_Out
SELECT ItemsPK, ItemsListName
FROM qryTransactionsExtended
WHERE...
Yes, Current stock result is ok, but the branches transfers should have to be shown only current month transfers but it's including the previous month transfers.