JithuAccess
Member
- Local time
- Today, 05:29
- Joined
- Mar 3, 2020
- Messages
- 297
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 Correspondences of these 8 Departments. Then I created 1 main Report and 8 Sub Reports in that Main Report to show the total Correspondences of all the 8 Departments.
I think this is a very unprofessional way. I want to store the query results in a Temporary Table and in this Table I will be storing the Total Incoming and Out Going Correspondences of 8 different Departments. Then I will be creating 1 Report and giving this Table as Record Source. This would be for Weekly Stats and then I will be creating 2 other Temporary Tables for Monthly and Yearly stats and then Reports. So there will be only three Reports.
This would be my Table:
and in this Table I will be storing the Query Results
Could you please let me know how to do this?
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 Correspondences of these 8 Departments. Then I created 1 main Report and 8 Sub Reports in that Main Report to show the total Correspondences of all the 8 Departments.
I think this is a very unprofessional way. I want to store the query results in a Temporary Table and in this Table I will be storing the Total Incoming and Out Going Correspondences of 8 different Departments. Then I will be creating 1 Report and giving this Table as Record Source. This would be for Weekly Stats and then I will be creating 2 other Temporary Tables for Monthly and Yearly stats and then Reports. So there will be only three Reports.
This would be my Table:
and in this Table I will be storing the Query Results
Could you please let me know how to do this?