Adding data to a query

[Guest]

Hi! Is it possible to add data to a query - much like an append quary adds it
to a table?
I want to join 3 tables to a query, to make a report where the data in the 3
tables is "sorted together". The reason I don´t want to use append query is
that I want the "joined" query or table to be updated automatically when new
data is added to the original tables. That wouldn´t happen with append
queries.

Anybody have any ideas?

 

[Duane Hookom]

This is the type of question that some samples would help tremendously. A
WAG suggests you can use a Union query. This also suggests you might have
more than one table with similar structures which might not be the best
design.

 

[Guest]

Thanks, I´ll look in to that. Just gotto find it on my Swedish Access version..

To be specific, the database is on fish presence in lakes. The 3 tables
include presence, extinction and stocking, respectively. Common for the three
is columns with lake-ID, year and species.
Now I am making a presentation using a form (one page/lake), where the data
from the 3 tables is mixed, so that it can be sorted by year and species (to
display "the history of the lake" when it comes to fish presence,
establishment and extinction).
Using an append query I have gathered all the data in one table, but the
question was whether it would be possible to do that using only queries - in
order get the summary-table updated automatically when the data is added to
the original tables.

"Duane Hookom" skrev:

 

[Duane Hookom]

I think a union query would work.