Due to an odd DB design by one of our vendors, I must use a union query to extract the information that I need. To keep things straight, I would like to put a memo before each of the some 20 UNION SELECT statements I must have. I would like to have something similar to the following:

--Experience Rating Factor--
SELECT [NFAC]
FROM [PRPPRF]
WHERE [LMATCDE]= "IRM002"

--Expense Mod--
UNION SELECT [Mid([lcdedta3],1,5)/10000
FROM POLPLC

Is there any SQL syntax that allows for memos so I don't get completely lost if I need to make changes to this 12 months from now? Thanks for any advice.

If by memo, you mean add a comments field inside the SQL statement, the answer is no. You can however right click on the querydef name and add a comment in the description field. This comment will show next to your querydef name on the query tab of the database window.

Thanks Pat. I didn't think you could add comments in SQL, but I wanted to double check anyway. Thanks again for the feedback.