Can I merge table data temporarily

=?Utf-8?B?S2FyZW4=?=

Guest

Posts: n/a

23rd May 2007

I have data (timestamped events) in a couple tables that I'd like to do some
analysis on, but across all the tables. The fields of interest are named the
same across the tables, but there's a lot of different additional information
between the tables so merging them permanently isn't practical.

Is there a shorter way than creating a table just for the analysis,
appending records from the tables, doing the analysis and then deleting the
extra table every time?

« Re: "File located outside intranet" | Issues with Rounding (or lack thereof) »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Can I merge table data temporarily	Kerry	Microsoft Access	0	23rd May 2007 03:34 PM
Re: Can I merge table data temporarily	Kerry	Microsoft Access	0	23rd May 2007 03:33 PM
Merge data into a table...?	Kenneth	Microsoft Word Document Management	8	12th May 2005 02:44 PM
Merge data from smaller table into larger table	Taz	Microsoft Access Database Table Design	1	10th Mar 2004 08:18 AM
Merge data from part of one table into a larger table.	Taz	Microsoft Access	2	9th Mar 2004 11:24 PM