I
Iceman
I have two tables the fields names are identical, the difference is one table is this years data and the second is last years data. How can I query these tables that results in all the data from both tables
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Michel Walsh
Hi,
You should have just one table, with a field for the year, if you don't
already have a date_time field.
It is not lost, but may be slower. Build the query:
SELECT 2003 as TheYear, field1, field2, fiedl3, .... FROM table2003
UNION ALL
SELECT 2002, field1, field2, fiedl3, .... FROM table2002
and save it. Use that query, rather the original tables. Since you can't
build an index on a query, that may be slower than if it was a table, but
otherwise, it works, technically.
Hoping it may help,
Vanderghast, Access MVP
these tables that results in all the data from both tables
You should have just one table, with a field for the year, if you don't
already have a date_time field.
It is not lost, but may be slower. Build the query:
SELECT 2003 as TheYear, field1, field2, fiedl3, .... FROM table2003
UNION ALL
SELECT 2002, field1, field2, fiedl3, .... FROM table2002
and save it. Use that query, rather the original tables. Since you can't
build an index on a query, that may be slower than if it was a table, but
otherwise, it works, technically.
Hoping it may help,
Vanderghast, Access MVP
table is this years data and the second is last years data. How can I queryIceman said:I have two tables the fields names are identical, the difference is one
these tables that results in all the data from both tables
I
Immanuel Sibero
Hi Iceman,
From the help facility, do a search UNION.
That said, it's not common strategy to have two or more tables that are
exactly the same, one reason not to do it is you may find the need to
combine them in the future.
How about storing all years' data in one table with an additional date/time
field?? Especially since you obviously need to combine them (i.e. from your
question). The next you would probably want is to combine 3, 4, 5 etc...
years.
HTH,
Immanuel Sibero
these tables that results in all the data from both tables
From the help facility, do a search UNION.
That said, it's not common strategy to have two or more tables that are
exactly the same, one reason not to do it is you may find the need to
combine them in the future.
How about storing all years' data in one table with an additional date/time
field?? Especially since you obviously need to combine them (i.e. from your
question). The next you would probably want is to combine 3, 4, 5 etc...
years.
HTH,
Immanuel Sibero
table is this years data and the second is last years data. How can I queryIceman said:I have two tables the fields names are identical, the difference is one
these tables that results in all the data from both tables