I have 10 tables, 30+ fields on each table (every table has the same 'account number' field). I only need from 5 - 20 fields from each table. How do I get the certain fields from each table and put them in a table, query or report?
Novice
Windows XP 
Access 2010 32bit
I have 10 tables, 30+ fields on each table (every table has the same 'account number' field). I only need from 5 - 20 fields from each table. How do I get the certain fields from each table and put them in a table, query or report?
VIP
Windows XP Access 2010 32bit
Might need to know more about table structures. Are these related parent and child tables and you need to join the tables. Or are these tables with identical structure and you need to union them?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
query average of multiple tables, output to existing table
multiple fields from single table update/select query
Posting Permissions
Reply With Quote