Recent content by ahmad_rmh

  1. A

    Solved Filter data based on crosstab query as per the dates criteria

    Thanks a lot , Arnel, 🌹❤️🌹
  2. A

    Solved Filter data based on crosstab query as per the dates criteria

    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
  3. A

    Monthly Sequence Sorting Order in Crosstab Query

    How the programmers are implementing months as like mmmm - yyyy
  4. A

    Monthly Sequence Sorting Order in Crosstab Query

    I have attached a sample db file, I have tried but not getting the results what i am expecting
  5. A

    Monthly Sequence Sorting Order in Crosstab Query

    My colmun names are changing dynamically
  6. A

    Monthly Sequence Sorting Order in Crosstab Query

    I don't want to fix column names as I have already mentioned in post #9
  7. A

    Monthly Sequence Sorting Order in Crosstab Query

    I don't want to specify the column names I want month name before year, what would be the technique, I should have to use.
  8. A

    Monthly Sequence Sorting Order in Crosstab Query

    But how could I get year name at the end?
  9. A

    Monthly Sequence Sorting Order in Crosstab Query

    Thanks It's working, What's the logic used in programming "yyyy-mmm-dd"
  10. A

    Monthly Sequence Sorting Order in Crosstab Query

    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
  11. A

    Monthly Sequence Sorting Order in Crosstab Query

    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...
  12. A

    Solved Stock Summary Issue in crosstab query

    Thanks plog, done,
  13. A

    Solved Stock Summary Issue in crosstab query

    ok, got it, 1. sample db file is attahced herewith. 2. pdf is attached for the expected results.
  14. A

    Solved Stock Summary Issue in crosstab query

    I have attached updated db file with only item for sample. Excel file is not attachable with me. I have attached pdf
  15. A

    Solved Stock Summary Issue in crosstab query

    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.
Top Bottom