Comparing dates in Access

[Rich24]

Hi, I’m new to the forum, and getting better with Access, but I’m still pretty new t it. I’m trying to write a query that will compare dates of food inspections. I need to check over a 3-year period if any inspection has lapsed more than 7 months from the previous. For each record I need to compare date 1 to date 2, if not more than 7 months then compare date 2 to date 3, and so on. If any 2 dates are more than 7 months, the record must be selected.
I used a little SQL in school a few years back, but I’m sure I could figure out how to do it if you can give me an example of the syntax.

 

[r937]

select stuff
  from yourtable
 where datediff('m',date1,date2) > 7
    or datediff('m',date2,date3) > 7

rudy

 

[Rich24]

Thanks Rudy, it worked like a champ. Can you recommend a beginner’s book on SQL? Just need something with the basics and a lot of examples. Thanks again.

Rich

 

[r937]

Introduction to Structured Query Language

http://riki-lb1.vet.ohio-state.edu/mqlin/computec/tutorials/SQLTutorial.htm

SQL Tutorial

http://www.w3schools.com/sql/

A Gentle Introduction to SQL

http://www.dcs.napier.ac.uk/~andrew/sql/

 

[Rich24]

Great sites!! Thanks again!