I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a time. To create a datediff function for all the possible combination of dates would take a long time. Is there any way to make a simpler expression.
This is my first time using this site so if more detail is needed please let me know.
April 2, 2010 2:04 AM
April 8, 2010 12:30 AM