Search results

Thanks a lot , Arnel, 🌹❤️🌹

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

How the programmers are implementing months as like mmmm - yyyy

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

My colmun names are changing dynamically

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

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.

But how could I get year name at the end?

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

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

Thanks plog, done,

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

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

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.

I am making a stock summary in crosstab query. The criteria is as under; 1. Current Stock should have to be the net present stock, i.e, (Opening+Purchases-Transfers) 2. Branches stock should have to be only current month transfers. how to get this. db file is attached herewith. kindly suggest

It just show datasheet form in report view, I want to show as a report view.

thanks CJ, & Arnel, Done & Solved, Now I want to implement the same way in report. How to implement?

Doing in the same way but as the new data columns added in cross tab query the sub form just showing the old columns and not adding the new columns.

I want to make datasheet form or List box but the columns should have to be shown in datasheet form or List box dynamically as per the availability of data in cross tab query. suggest please.