Union Query in Access 2000

[KEKeogh]

Hi all!

I have two queries with the same columns that I would like to combine into one. eg: [End Times] query retruns 4 results and [Pickup Times] query returns 4 different results. I want a new query to list the results from both queries resulting in 8 results.

Through research I know this has to be done using a Union Query in the SQL format but I can't figure it out.

Here is the info on the Queries.

1st Query Name = [End Times]
2nd Query Name - [Pickup Times]

Columns for both queries = LAST, FIRST, PROGRAM NAME, SESSION, DATE, PICKUP

Any help is appreciated. Like I said I can't figure out the SQL code to save my life.

I don't need the results ordered or filtered any further than what's in the original queries.

Thanks
Kathie

 

[Alansidman]

Try this:

Select [End Times].*
From [End Times]

Union

Select [Pickup Times].*
From [Pickup Times];

Alan

 

[KEKeogh]

Alan! You are the BEST!!!!!

Something so simple but it was alluding me. Worked perfectly!

Kathie

 

[Alansidman]

You are welcome.