help

  • Thread starter Thread starter SJJ via AccessMonster.com
  • Start date Start date
S

SJJ via AccessMonster.com

i have three different tables and each table contain date field and time
field.
is it possible to pull all of the dates from 3 tables and save it on a
different table under same field. same with the times.

thanks
 
i have three different tables and each table contain date field and time
field.
is it possible to pull all of the dates from 3 tables and save it on a
different table under same field. same with the times.

thanks
Click to expand...

As noted in the other thread... please describe your table structures
and explain more clearly what you're trying to accomplish.

The answer is probably yes (with Append queries), but I hesitate to
advise you in detail until I understand what you're trying to
accomplish and with what basis.

John W. Vinson[MVP]
 
SELECT SJJdate1 as SJJDate
FROM Date1table

UNION SELECT SJJdate2 as SJJDate
FROM Date2table

UNION SELECT SJJdate3 as SJJDate
FROM Date3table

The above sql statement gets you the dates though a union query.
 
Back
Top