SQL Stmt Joined to a saved query -

[kschuster]

I'm using VBA to generate a dynamic sql statement. In Access Query designers you can relate a table to a query result. that would look like

SELECT tblStateTax.StateAbbr, SOurce_Recon.Source_Count, SOurce_Recon.Source_Cost
FROM tblStateTax LEFT JOIN SOurce_Recon ON tblStateTax.StateAbbr = SOurce_Recon.State;

WHERE - Source_Recon is the Query and tblStateTax is the TABLE

How would I write the above query REPLACING Source_Recon (a saved query) with the actual sql from Source_Recon?
Thanks

 

[Crowley16]

wrong forum, try posting in the access queries forum...

--------------------
Procrastinate Now!