Search results

Thanks Isladogs (is that right ?). Spot on. I changed the format of mThisWkSt to mm-dd-yyyy and it worked like magic. Saved me a roundabout solution of having custom queries for each option report. Cheers!

Further, I typed in the following in the immediate window : mst=#05-01-20# ? DateSerial(Year(mst), Month(mst), Day(mst)) 01-05-2020 Clearly if the short date format is set to dd-MM-YYYY then this will look for date in May which is not what was wanted. Can I use the Format function with...

Thanks. Does this, as already programmed, have the same effect : mThisWkSt = DateSerial(Year(mThisWkSt), Month(mThisWkSt), Day(mThisWkSt)) similarly for mThisWkEnd; also for This Month and other options. Followed with : strSQL = strSQL & "[TrdDt] >= #" & mThisWkSt & "#" All of the...

Thanks a ton. Although it is still not rectified - I have changed my settings to short date dd-MM-YYYY and also after restarting Access set the date field in the table and report to Short date - I am sure this is the problem. I'll explore till I get it right - maybe restart the laptop. I thought...

Thanks for your invitation! Hope to have a useful interaction.

The issue :- As a lark I ‘wrote’ a program in MS Access to display my daily trades – brokerage and taxes, gross profit and net profit. The main points and issue are :- tblTrdMain has 6 records of trades for 6th and 7th Jan 2020. The table has an indexed field named ‘TrdDt’. To view reports...

Hi, I am an occasional Access programmer with a little more than basic experience. From India, Bangalore. I have interests in nature, trekking and reading. Hope you all the best in your pursuits. Best wishes for a New Year and alsways.