Hi,
I have a form that can enter start date and end date.
I want to create a table which contains a list of date between start date and end date. i know that from query we can write SQL to create the table but i don't know how. The data of the table will change according to the start date and end date.
Example:
Start Date : 1/1/2000
End date : 1/1/2004
The table will list all dates between the Start Date and End Date.
But, if the Start Date and End Date change, it will delete the current data and create a new list of dates between the new start date and end date.
Really need help because i have browse the internet searching for the correct SQL but failed.
Thank you