I am using Access to populate an Excel sheet, and someone around here came up with the idea of storing SQL statements in an Access database. The proble is, sometimes we need to use variables in our SQL statements. So the SQL statement 'Select * from Hdr_Reports' stores and runs fine, but if we need to store 'Select * from Hdr_Reports where Report_Name = ' & VaribleName & ', we can figure out how to make VBA read the line correctly. It translates it all to a literal string. Any idea how to get around this? Thanks in advance for your help.

Did you try this?

'Select * from Hdr_Reports where Report_Name = "' & VariableName & '"'