one report, taking data from two tables with similar columns

[ttbeverley]

Gday guys,
Had a very successful morning with the help of Mike375's expert help with queries, now i have a new problem.

I have 2 tables, with a time field in both, what i would like to do is combine both of these tables into a report that is sorted by the shared field.

If i was to use 2 seperate fields, it would work fine, but i would like all times in the one column.

the other fields shown on this report will all need to have data shown from the two other tables as well.
Fields showing are time, device, message, location (on report)
fields on table are of different names but there is still time, device, message and location in each.

Is this possible? or am i trying to do somethign that access 2007 simply cannot do?

Thanks in advance.

 

[tuxalot]

Are you familiar with Union queries? Google it to see if this approach would be useful for your data.

 

[ttbeverley]

Are you familiar with Union queries? Google it to see if this approach would be useful for your data.

Gday Tuxlaot.....

Union queries look like exactly what i want, but i have a beginners question for you.....

The union query part is fine, i think i can figure out how to use that, but i am using queries already in this report, so when i go to the query for that report, and then go to SQL view to see the view that i need to modify in (accoring to the website i was looking at), where do i inser the union query?
There is also the option in access 07 to click the union query in the design tools up top, do i use that window to create the union then leave the rest to the sql view (or the simple access interface which i have been using)?

Thanks again for your pointer, definately the result that i want to try and achieve

 

[ttbeverley]

Ok so i finally figured it all, thanks very much to Tuxalot for pointing me in the right direction. For anyone else looking to do this, the easiest way is to follow directions on address http://office.microsoft.com/en-us/access/HA102061091033.aspx

This has step by step instructions of combining queries (including union) so that you can create a query, then use union to join the two queries to create the output.

Thanks again Tuxalot.