Two tables fields into one query field??

[crann]

I am a beginner

I have two tables: tbltasks & tblsafety

Both tables have a date field in, one table keeps tracks of my tasks the other the expiry date of some safety checks.

I currently have a timed pop up that looks at dates within a table that are within 30 days from now, if there are any dates the reminder pops up.

The problem is I want the pop up to look at two sepearte columns in two different tables, so I figured it would be easier to create a query combining these dates and just ask the pop up to look at that query date column.

I want to create a query that very simply lists all the dates in one column combined from both tables.

Is this possible and how

Thanks for any help

Jon

 

[plog]

Most likely this will be achieved with a UNION query (http://www.techonthenet.com/sql/union.php). If you would like specific instructions post sample data, I would need 2 sets:

A. Starting sample data from your 2 tables (include field and table names).

B. Based on the sample data in A, what you expect the query to return.

 

[crann]

Hi

I have attached two simple tables, is it possible to create a query that displays the data from both in combined columns

So I end up with a column that displays Satefycheck & Task together and then the next column their related DueDate and TaskDate.

So effectively its provding a list of descriptions and dates from two different table fields.

Hope that makes sense

Jon

 

[plog]

Not really.

Sounds like you provided me A. Now provided me with B.