add new field to all previous tables in queries

DavidAC

Board Regular
Joined
Feb 10, 2003
Messages
127
hi,
i have a DB which has been requested to have additional fields added. is it possible to do a multiple update to all queries etc to add this new field to save time and ensure that all queries are updated.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,059
Office Version
  1. 365
Platform
  1. Windows
It would be possible but would require code.

You would need to loop through every query definition and rewrite the SQL behind them.

You would need to specify the fields to add and how to add them.

Can you give some more information?
 

DavidAC

Board Regular
Joined
Feb 10, 2003
Messages
127
i need to add a yes/No field to a table, then every query that is linked to the table needs to be updated accordingly to ensure data integrity.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,706
Members
412,481
Latest member
nhantam
Top