Search results

I've added dd for 01 =Format([Enter Start Date], "dd-mmm-yyyy")

Done Thank you so much dear.

Thank you so much is there any way to 1-Jan-2021?

Asking for Date Parameter Value

Will this show the current year?

Yes some time I type just 1 Jan and I get the report according to date range.

Yes because Its the some of different dates by Head Of Account wise. But PaymentDate field was necessary because I want this report for a specific date range. And I also want that date range to show on the top of my report.

Yes my dear I've tried But Its not showing proper date. Not showing year. I have to type complete date every time like: 1-Jan-21. Is there any other solution?

Thank you very much to all of you! My issue has been resolved in Petty Cash Report by Creating TextBox with Control Source =Min([PaymentDate]) and =Max([PaymentDate]). But the same problem is in another report Let me show you its Query: The PaymentDate is not visible in my report . When I am...

SELECT HeadOfAccount.hACID, DebitVoucher.HeadOfAccount, Sum(DebitVoucher.AmountPaid) AS SumOfAmountPaid FROM HeadOfAccount INNER JOIN DebitVoucher ON HeadOfAccount.hACID = DebitVoucher.HeadOfAccount WHERE (((DebitVoucher.PaymentDate) Between [Enter Start Date:] And [Enter End Date:])) GROUP BY...

Thank you so much dear. But it is missing some IDs because there is no values. HAC-06 HAC-10 HAC-13 HAC-14 But I want to show all HeadOfAccounts. Please guide how to show all of them?

I've Created a Query that is working fine without date range. Let me share its design and datasheet views: DESIGN VIEW DATASHEET VIEW But when I am trying to add date field like this: Its not combining the values like this: Actually I want to give date parameter to make the overhead report...

I am beginner did not work on module before. I tried it. But I am confused in last steps. Like how to call this function SayNo(YourNumericalValue)

Hi, Can anyone guide me to how convert number to words? For example I have two fields a field of 1) Amount 2) Amount in Words If Amount = 1000 Amount in words should = One Thousand Only Thank you.

Thank you so much to all. Solved

I saw many time its Landscape. You can see Check here also

But the width of my report is 11.125 means A4 size. How its possible to cut my half page? Report's orientation is Landscape but its margin in layout view seems like portrait. You can see in the image below:

Done but still same problem

You can see all margins are 0.25, Orientation is already Landscape, Page Size is A4, Report Width is already 11.125".

Yes its already Landscape.