Save Button (Worksheet)

Clicking the Worksheet's Save button writes a permanent record of the current SQL sequence into your database. By "permanent" we mean that once you named and save this query sequence, it's yours and won't be deleted by Access ELF, the way it removes it own temporary queries. These queries will stay in the database container until you choose to delete them.

The Save button saves the entire chain of SQL steps belonging represented in the Worksheet, regardless of the position of the selected (Q1-Q7) radio button. You can select any legal query name for the saved queries, according to MS Access naming conventions. (For example, the dot "." character is not permitted in query names.) The number of each step in the SQL sequence will be appended onto the end of your query name, so that a 4-part query might wind up saved as MyQuery1, MyQuery2, MyQuery3 and MyQuery4.