Hi everyone
I have been asked to create a database which will be used by several departments.
My question is about queries in general.
As someone else might make changes in the future, I want to keep it as maintainable as possible.
Should I create a query object for every (SELECT) query I do (some forms might have several)?
Is there something like a golden rule / best practise or does it not matter?
Or maybe I should ask the question another way: What would you like to see when you take over someone else's Access project?
Thanks
Massimo
Ensure that users can't touch the queries.
Personnally, I tend to write queries in the code, indented of course.
Something like the Following:
Open in new window
Column names, criteria in the WHERE clause are aligned, and FROM clause is indented, this way the sql variable's content is easy to read in the code as well as in the execution window.