I have one large table from which many different forms spawn. Each form has its own unique fields, but most all of them contain the same data. For instance, I have three different fields that contain company codes, but they are named "Write Off Co Code", "Vendor Co Code" & "Check/Wire Co Code". I can't say why they used three different fields for the same data when this db was created, I wasn't here then. Anyway, I need to create a query on the three different sections of data: write offs, vendors and checks. How do I create a query (or make-table query) that will combine the identical fields? I figure a Union is what I need, but I don't know SQL to save my life and am not sure how to make it work since they are all in the same table in the first place. I'm assuming something like this: Select[Write Off Co Code] from [Adjustment Table] Union Select[Vendor Co Code] from [Adjustment Table] Union Select[Check/Wire Co Code] from [Adjustment Table] Then I don't know what to do next. I think I need an "As" statement after that, but not sure what it should look like. Maybe: As[Co Code] in [Adjustment Table] Any help is much welcome and appreciated.