2 date fields to 1 ?

[ThaiByThai]

Hello -

I'm not sure if i am going about this the correct way... I have a table with 2 different date fields - 10years date and 5years date - i would like to combine the 2 fiels to one and call it ALLdate:

so this is wha i would like to have the final result to look like

Field:10yrs date
2/1/2020
3/1/2020

----

Field:5yrs date
2/1/2015
3/1/2015

---

FINAL result Field: ALLDate
2/1/2020
3/1/2020
2/1/2015
3/1/2015



I try to do this - ALLdate: [10yr date]+[5yr date] --- but not getting any results...


please help. thank you

 

[DCrake]

Take a look at union queries

 

[vbaInet]

Your tables are not normalised. The result table your seeking is actually how your table should have been built in the first place. Perhaps you want to read more about this:

http://support.microsoft.com/kb/283878

You certainly will have more problems in the future if this isn't addressed now.

To answer your question you can use UNION.