Search results

Thanks. I will update you the Progress.

Thanks a lot for your suggestion. I think I need to create a Union Query and this is the only solution. Let me try.

Thanks a lot for your reply. We want to know how many Correspondences we Sent and Received from and to each 8 Different Departments. For Example in the past week we may received 8 Incoming mails and we have sent 10 Outgoing mail for Department 1. For Department 2 we may received 2 Incoming...

Because we have 8 different Departments. Let me try Union Query. Thanks for your suggestions

Hello Guys, Could you guys please let me know how to store query results in a Temporary Table? I was preparing a Weekly, Monthly Yearly Mail Logs Report. There are 8 Tables belongs to 8 Different Departments. By running 8 Different queries I am capturing Total Incoming and Outgoing...

Many Thanks for your Help

Thanks a lot. It worked Perfectly

Yes it is. Thanks

Hello Guys, In my query I have filtered the date field as: Between Date() and Date()-7 To filter a week's Data. Is there any method to filter the Dates Between the Date of Monday and Friday based on the current week. For Example, Today's date is 20-Apr-2021 and Today is Tuesday. I want to...

Hi, I think I solved this. I have created a query to get the Total count of the Records based on my two criteria and then create a Subreport then in the Record Source give that query and it's working fine. Thanks

Thanks let me check

Nope. and if I give like Sum(IIf([datApplication Datem]Between Date() and Date()-7,1,0)) I am not getting Error. But if I am giving these two criteria together I am getting Error. Thanks

Yes these are my Table's Fields

Thanks a lot. But when I am giving Sum() or Count() I am getting the Error and if I am using =iif it is just showing Record count as 1 (True Value Part). Could you please let me know how to crack this. Thanks

Yes. But there are 2 Records and in this Report the Count is showing as just 1. Thanks a lot for your Help

=Sum(IIf([strProgram]="Primary" And [datApplication Date] Between Date() And Date()-7,1,0))

Yes, Unfortunately.

This is my Code =Count(IIf([strProgram]="Primary" And [datApplication Date] Between Date() And Date()-7,1,0)) "1" is True Part and "0" False Part. But unfortunately I am getting same Error message Thanks

Thanks a lot for your suggestion Sir. Let me find the correct Syntax. Thanks a lot for your Effort and Time.

Sorry. But there were 4 other Reports and this Function is working fine in all these Reports with this Syntax =Count(IIf([strProgram]="Primary" And [strNew or Additional Information]="New" And [datReceived Date] Between Date() And Date()-7,1))