This website is my personal programming archive of programming tips, tricks and solutions to problems I have encountered.
Not only is this a good place for me to check back on things that I have done when I am searching for a new solution, but I hope that you may get some value from it too.
The SQL/ MSAccess techniques here are designed such that they can be used interchangeable, so the SQL used is non-procedural as far as possible. Its often easier to solve a problem using the procedural approach, but what then if you are forced to convert from one database platform to another where one platform does not support procedural queries, or what if you are forced to use MSQuery to ad-hoc query a database? Often the most elegant solutions with the least lines of code come from a well thought out query as opposed to resorting to slower procedural logic.
Google for "MikkyThomeon" on the net - that is my unique acronym.
I am not available to answer your questions, but if you feel that you have a better solution, then please comment in the places provided.
Enjoy!
Mike Thomson