MS Access SQL How to put a table name as Variable (how to run one query for multiple tables)

Question

Lets say I have a query like this:

Parameters Table_Name string, Field_Name string;

Update Table_Name Set Table_Name.[field1] = "new value", Table_Name.[field2] = "new Value" Where Table_Name.[Field_Name] = "Some value"

Basically I have the same query which I need to run against different tables which share some fields together. I want to be able to type the table name when I run the query.

I know this can be achieved with VBA, but this way would be a lot easier than VBA. Although VBA is also welcome but I would like to be able to do this in pure SQL.

How to achieve the above logic for table names AND field names?

David T. Macknet · Accepted Answer · 2016-11-16 17:04:53Z

2

Is this being done in MSAccess or in SQL Server? If you've got a SQL Server behind things, then you'll be looking to do some sp_executesql calls to get the job done. If you're doing this in MSAccess, you can accomplish the same by building dynamic SQL statements in VBA - either way would work if you've got Access pointing to SQL, though.

answered Nov 16, 2016 at 17:04

David T. Macknet

3,1803 gold badges29 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MS Access SQL How to put a table name as Variable (how to run one query for multiple tables)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related