Search results

Apologies. He doesn't have Access to the Folder where the Database is Backing Up to

Sorry. He Doesn't. I totally forget about this. Apologies :oops:

Hello Guys, I have an Auto Back Up code in the Exit Button click of my Database. It was working fine. Due to COVID my colleague is working from home. He is Using Windows 10. When he is clicking on the Exit button, he is getting an Error like “Run Time Error 70 Permission Denied” Could you...

Thank You. I will go with Query

Can we give something like [StrEmp ID]=Unique in the Criteria? Thanks

Hello Guys, How can I use Distinct Function with DCount? This is my Code =DCount("[strEmp ID]","[tblMonthly Report Raw Data]","[datPayment Date] Between #2020-04-01# and #2020-04-30#") I want to find the Unique Employee ID. there are Total 10 Employee IDs and 2 of them are Repeated and in my...

Thanks a lot. I fixed it. I used "Is Null" and it worked Perfect. In my Programs Fields there are 3 Values "M", "H" and Blank (Null) I want to find the total of Blank (Null) and I use this code: =Nz(DSum("[curTotal Paid]","[tblPayments Final]","strProgram Is Null),0) Thank You

Hello Guys, I want to find the Sum of the Payment if the Program is Not Equals to "M" Or "H" and I have given this Code =Nz(DSum("[curTotal Paid]","[tblPayments Final]","strProgram<>'M' Or 'H'),0) But I am getting an Incorrect Result. I think the Logic is wrong. Could you guys please help...

Thanks a lot. Sorry for copying and pasting Codes without really understanding what that codes meant for. I have changed my code: =DCount("strProgram","[tblMaster Table]","strProgram='ABC-123' And datDecision Between DateSerial(Year(Date())-1,4,1) And DateSerial(Year(Date())+0,3,31)") And this...

Thanks a lot for your Reply. I have changed my code to: =DCount("strProgram","[tblMaster Table]","strProgram='ABC-123' And datDecision Between DateSerial(Year(Date())-1,4,1) And DateSerial(Year(Date())+0,3,31),1") But still getting same #Error Thanks

Hello Guys, In my Report I am using DCount Function to find the Total Number of Decisions made in a Month by Program and this is my code =DCount("strProgram","[tblMaster Table]","strProgram='ABC-123' And datDecision Between DateSerial(Year(Date()),Month(Date())-1,1) And...

Thank You

Sorry. I fixed this. It works Perfect. Thanks a lot for your Help

Thanks a lot. It worked Perfect

Hello Guys, I want to find Total Decision made in a week in my Report and this is my Code: =DCount("strProgram","tblMaster Table]","strProgram='ABC-123' And datDecision Between DateAdd("d",-6-Weekday(Date(),2),Date()) And DateAdd("d",-2-Weekday(Date(),2),Date())")) Here in the criteria of...

Thanks a lot and Sorry for asking too much Stupid Questions.

Thanks a lot. It worked Perfectly. Got a small issue. There isn't any Payment made for May-2020 so in the Query Result it is not showing. But we need to show this in our Report as May-2020 $0.00 Thanks

Hello Guys, I was trying to Group Payment Amount with Payment Date. This is my Query: and This is my Query Result: As you could see, for July, the Total Payment was $221,260.00 and $22,126.00 and this is showing Separately in the Query. I think if there are different Dates, Query is...

Many Thanks. This worked Perfect

I have changed my Code like: =DCount("[strTransmission]","[Table1]","[strTransmission]='A:B' And [datPayment Date] Between '#2020-04-01#' And '#2020-04-30#'") But still getting same #Error in my Report. Thanks