I have a table with 30 fields, but not all records have the same field names. For instance, Type A record has 30 fields, Type B record has only 15 fields, but only a few of the fields are the same as Type A. As I have the information regarding whether it is a Type A or a Type B record, I run queries to separate the types of records into their respective tables, where I can then apply meaningful field names. I can think of a lot of complex ways to do this (i.e. query to a temp table, cut and paste the records into a table with predefined field names and then before I run it the next time, do a delete query to clear the records from the table with predefined field names), but I am wondering what the cleanest way to do this would be. Due to the data source, the data has to pull in this way, and I am trying to sort it out in the database. However, I do not want to store the data and want to sort the data into tables so that I can work with it while I need to and then override it the next time I pull data. Hope this makes sense! Any ideas are appreciated!