I retrieve records of members in the company legacy database and use them in a MS Access database via a csv file that the afore mentioned SQL ultimately creates. I can get the legacy database to create the csv file from a menu item in the program software but that csv file returns far more data than I need (columns and extraneous rows) so I have to use an Excel spreadsheet and VBA to massage the data to what I need then have the Access database fetch the data from the Excel spreadsheet. We use oooold versions of Access and Excel and I have problems there, also I'm the only one that does it and if I don't it doesn't get done (each morning).
I'm going to have the SQL, of which the afore mentioned WHERE clause is a part, run in a SQL Server Agent job and create the csv file which the Access database can then take in directly. All this is going to be moved to another platform in a year or two. I'm just trying to get the job numbers in the WHERE clause without having to change the SQL each time I want to add a job(s) or take out a job(s).