Home > IT Answers > Microsoft Windows > MS Access query to show records that contain dates that differ by 1 year
SerenityNow36
5 pts.
 MS Access query to show records that contain dates that differ by 1 year
Access, DATEDIFF, Microsoft Access 2003, Microsoft Access query, Query
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. 


Software/Hardware used:
Access 2003
ASKED: April 2, 2010  2:04 AM
UPDATED: April 8, 2010  12:30 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Having 15 date fields could be a sign of poor database design. Things could be easier if those dates were in different records (in the same column).

Do you need to check for an exact year difference ?

carlosdl
 63,535 pts.