Hi, I have a very odd requirement, and am unsure if its even possible, but here goes...
I have a number of queries which create produce data in a similar form, but in very different ways - i.e. there isn't any way of combining them.
E.g.
Query1:
ID Field1 Field2
123 12 23
234 23 34
Query2:
ID Field1 Field2
987 98 87
876 87 76
I want to combine these in a similar way to an append query, but combine all the data into a query, since the source data changes regularly, and I want to keep the results of this mega query consistent with the source datatables. So the result would be:
Combined Query:
ID Field1 Field2
123 12 23
234 23 34
987 98 87
876 87 76
I seem to remember doing something similar in the past, but can't remember how? Any suggestions would be appreciated...
I have a number of queries which create produce data in a similar form, but in very different ways - i.e. there isn't any way of combining them.
E.g.
Query1:
ID Field1 Field2
123 12 23
234 23 34
Query2:
ID Field1 Field2
987 98 87
876 87 76
I want to combine these in a similar way to an append query, but combine all the data into a query, since the source data changes regularly, and I want to keep the results of this mega query consistent with the source datatables. So the result would be:
Combined Query:
ID Field1 Field2
123 12 23
234 23 34
987 98 87
876 87 76
I seem to remember doing something similar in the past, but can't remember how? Any suggestions would be appreciated...
