Search results

Yes [strTransmission] is the name of my Field and there are 2 Records A:B between 2020-04-01 and 2020-04-30. Thanks

Thanks a lot

Hello Guys, I was trying to find the Total count of Records based on 2 criteria in my Report. This is my Code: =DSum("[strTransmission]","[Table1]","strTransmission='A:B' And [datPayment Date] Between #2020-04-01# And #2020-04-30#") But I am getting #Error Could you please let me know how...

Hi, I think I solved this. I use DSum Function and it is working. Thanks a lot for your Help

Thanks it worked perfectly. I know I am annoying you sorry about that. How to find the Total Sum of Payments made between these Dates? I have another Field [curPaid Amount] and how to find the Sum of this field by giving the criteria as Between 4/1/2021 and 4/30/2021. Sorry again for...

I gave like this: =sum([strClaim ID]iif([datPayment Date]between #2020-04-01# and #2020-04-30#,1,0)) But getting Error. Thanks

Thanks so much for your suggestion. My fields are [strClaim ID] and [datPayment Date] I want to find how many claims we received in a month. So could you please let me know how to do this? Thank You

Sorry but Problem Not Solved. I am getting the count of Claims if I am not giving any criteria: =Count([strClaim ID]) But getting Error when I am giving criteria like this: =Count([strClaim ID]) where [datPayment Date] Between #2020-04-01# and #2020-04-30# Thanks

Thanks a lot

Hello Guys, In the Unbound Text Box control I have put the following Code =Count([strClaim ID])(iif([datPayment Date]) between #2020-04-01# and #2020-04-30#) I want to find the Total Number of Claims ID Between 01-Apr-2020 and 30-Apr-2020 I am getting an Error: I think the Syntax is...

Thanks a lot

Hi, Thanks a lot. Now I am getting like: Two issues: I want to sort this data by Month. Like Apr-20, May-20, Jun-20...Mar-21 Second issue, though there isn't any Record for May I want to show like Month Total ----------- ------- May-20 0 I am attaching the Database...

Hello Guys, In my Table I have a field Payment Date. I want to find the Count of Payments made in a month. This is the data in my Table: I want to display like this in my Query: This is my Query: And this is my Query Result: Could you please let me know how to Fix this? Thanks

Thanks a lot. Do you have any idea how to do this? This is my Query: Select [Total Corrsepondence] from [QryDepartment1] Union all Select [Total Corrsepondence] from [QryDepartment2] Union all Select [Total Corrsepondence] from [QryDepartment3] Union all Select [Total Corrsepondence] from...

Hello DB Guy, I have created a Union Query and this is my Query Result: Could you please let me know how to use Cross Tab Query. The result should be like: Thanks a lot

Yes Got over Excited. Sorry

Thanks a lot. Let me first create the Union query.

Thanks a lot I tried Cross Tab Query but getting an Error Message like: Thanks

Thanks a lot for your Help.

Hello DB Guy, I have created 1 Select query to get the Total Count starting with 2 Departments and it is working fine. Then I have create a Union Query: SELECT [Dept1 Total New] from [Query3] UNION SELECT [Dept2 Total New] from [Query4]. But I am getting Query Result in Rows: I want the...