dates of holidays

[Database User]

Hello

I am creating a database for a college. I have a Table containing all the
dates of the terms. the fields are

Term Id - autonumber
Term Description - Spring, Summer, Autumn Winter.
Term Start Date - date
Term End Date - date

i now need to create a list of the holidays i.e a table showing beginning
date of holiday to end date of holiday.

So what i need is the end date of the spring term and alongside that the
beginning date of the summer term etc.
so i need the end date of one record and the beginning date of the next
record after that.
how do i do this - what is the code
thanks for all your help!!

 

[Allen Browne]

Use a subquery to get the matchine date from the next record.

For details on how to write that, see:
Subqeury basics: Get the value in another record
at:
http://allenbrowne.com/subquery-01.html#AnotherRecord

 

[Database User]

Hi

I think i'm on the right track but i just want to ask you something.
what does it mean that you have to create a duplicate table and alias it?

thanks so much for all your help

 

[Allen Browne]

You don't have to create another copy of the table.

You just have two instances of it in your query, and so you have to name the
2nd copy differently.