Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. caddiva1

    Union query 3 files with different fields

    Thanks!!! that works and I can now get rid of my bogus table I created to include all of the fields...once I realized I could use null
  2. caddiva1

    Union query 3 files with different fields

    That's not exactly what I meant. That would put all the data into the 3 fields. What I want returned is: Field 1, field 2, field 3, field 4, field 5, field6, field 7 the only common field is Field 1 and the results might look like this: group A, 25, $100, 0, 0, 0, 0 Group B, 0, 0...
  3. caddiva1

    Union query 3 files with different fields

    I have 3 files I want to combine: Table x with Field 1, field 2 and field 3 Tab;e y with Field 1, field 4 and field 5 table z with field 2, field 6 and field 7 how do I create a union query to get them all together: Select Field 1, field 2, field 3....field 7 from x How do I pad the tables...

Part and Inventory Search

Back
Top