Multiple Tables, One Query

[MFS]

I have numerous tables with similar information.
Example:


Table one has the following information . . . .
Device 1
Time
Date
Temperature

Table two has the following information . . . .
Device 2
Time
Date
Temperature

Table three has the following information . . . .
Device 3
Time
Date
Temperature

I have a few text boxes within the form that controls the criteria information for my chart. I do not know how to populate my chart with the data From Table 3, AKA Device 3 table, Or Table two, since my chart's 'Row Source' is predefined.

Any help would be appreciated.

[ranman256]

union query:

sql =
select * from tbl1
union
select * from tbl2
union
select * from tbl3

[June7]

Why not 1 table with another field for DeviceID? This is essentially the output of UNION query. Would expand the UNION query to include device identifier as a calculated field: "1" AS DeviceID. Also, using the * field wildcard assumes fields are all in the same order in the table design. There is no wizard or designer for UNION, must type in SQL View of query builder. Limit of 50 SELECT lines.

Darn, it's happening again - forum won't let me type UNION in the query example.

SELECT *, "1" AS DeviceID FROM tbl1
______ SELECT *, "2" FROM tbl2
______ SELECT *, "3" FROM tbl3;

[MFS]

June7,
The reason I have multiple tables is because I have a PLC sending data to my SQL DB. When an output goes high on the PLC the DB knows to pull defined tags of data into the database dependent on which trigger/output is high. I don't always want all the data for each device every time the trigger goes high so I use multiple triggers, one for each Device. Which would require one table for each device. (Whewwww, that is hard to explain)
I just completed ranman256's suggestion and it works perfectly. I created a Union Query and then a simple Query where I wrote my criteria using text boxes from my form.
Thanks June7 and ranman256 for your help.
I'm going to leave this post open until I return to work tomorrow morning. After I review that all is working well I will mark as solved.

[June7]

A UNION will not allow duplicate records which means if any records in one table are identical to records in another table, only one shows. Use calculated identifier field and/or UNION ALL.