I have a query that is based on a view that takes forever to run (and usually errors out due to TEMPDB running out of space.
In this query the view gets joined to itself and is used to filter by the maxof routercallsequence#
The base query selecting the view by date returns the days worth of data in about 4 - minutes. Certainly a usable time as the base table contains several million records and the query returns about 45k records.
So in essence I'm trying to join 45k records to themselves. there are no indices on the view and I am trying to get them added.
I can get to the tables via Access so if an Access solution applies so be it.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…