NauticalGent
Ignore List Poster Boy
- Local time
- Today, 13:46
- Joined
- Apr 27, 2015
- Messages
- 6,396
That old saying "if your only tool is a hammer..." became relevant to me today.
In the past if I had to pull data from more than one table, my first and only solution was to use temp tables and populate them. If it was a recurring requirement, the old data had to either be updated, new data appended and so one and so forth.
Not a big deal, easily done with macros and/or some VBA, but it seemed inefficient and I could not believe there wasn't a better way. Today I was faced with a similar requirement and the task was daunting and would have meant duplicating objects which I HATE to do. For some reason an untidy navigation pane is something I lose sleep over even though I am the only one who sees it.
My predecessor had designed a few Union queries that had not been used in years. When I got things down to a dull roar, I was going to look into what they did and delete them if I could not find any use for them.
When I realized what they do I felt both elevated and stupid at the same time. All the time I have wasted in the past with temp tables, forms and reports and the queries to populate them...jeez.
Never too late to learn I reckon!
In the past if I had to pull data from more than one table, my first and only solution was to use temp tables and populate them. If it was a recurring requirement, the old data had to either be updated, new data appended and so one and so forth.
Not a big deal, easily done with macros and/or some VBA, but it seemed inefficient and I could not believe there wasn't a better way. Today I was faced with a similar requirement and the task was daunting and would have meant duplicating objects which I HATE to do. For some reason an untidy navigation pane is something I lose sleep over even though I am the only one who sees it.
My predecessor had designed a few Union queries that had not been used in years. When I got things down to a dull roar, I was going to look into what they did and delete them if I could not find any use for them.
When I realized what they do I felt both elevated and stupid at the same time. All the time I have wasted in the past with temp tables, forms and reports and the queries to populate them...jeez.
Never too late to learn I reckon!