It seems to have I can be done with Common Table Expression(CTE).
Create table #temp
insert #temp values('F00000','W1099999')
insert #temp values('F00000','RPL12345')
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…