query to append query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I’m not familiar enough with access to solve my question. I hope there’s
someone who can help me here.
I have a Query (incoming) with the fowling fields: ID; Date; Quantity; Value.
I also have a query (Exit) with the fowling fields: ID; Date; Quantity.
I need a query aggregating this two.
So far I made this queries ( incoming and exit) append queries to a table
(movements), as:
ID; Date; Quantity; Value
ID; Date; Quantity; Value
ID; Date; Quantity
ID; Date; Quantity
ID; Date; Quantity; Value
ID; Date; Quantity; Value
I have already this data in other different tables. So I would like to
obtein this result in a query not on a table.
Is it possible?
 
Raul

If I understand your situation correctly, it sound like you could create a
third query, joining the first and second. To join the two queries, you
would need one/more fields common in both. You'd join on those common
fields, then include all fields from both queries that you wish to see.
 
Back
Top