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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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- caddiva1
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
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...- caddiva1
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
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...- caddiva1
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
