Merging data from a table and a query

[Debbie]

Hello all.

Here is my dilemna. I have four reports I am pulling in data for. The data
for three of the reports includes Date, Function, User ID, Queu, Volume, and
Time. Although the text files for these three reports were formatted
differently, I was able to build three modules to pull in these reports and
import the data into a single table.

However, the fourth report hase everything that the other reports have save
the time. It has a start time and a finish time. So I had to build another
table to import into and then a queury to calculate the time.

So now, I have a table with Date, Function, User ID, Queu, Volume, and Time
and a queury with the same information. I want to marry this data into one
queury so that I can create a report that captures all of the data.

How do I accomplish this?

Thank you for your help.

 

[KARL DEWEY]

I want to marry this data into one queury
Do you want the data laid out horizontally or vertically?
Horizontally - use a query with JOIN.
Vertically - use a union query.