I am trying to show up lines in a table with matching serial numbers and also term dates which cover roughly, the same period.

i.e. 2 Lines in a table with the same serial numbers and then the dates as follows. Line 1: 1-1-09 to 12-31-09
AND Line 2: 1-3-09 to 12-31-09.

Both lines cover pretty much the same period. But is there a way of querying for "Date1" = "Date2" PLUS OR MINUS A FEW DAYS?????

Really stuck on this one!! Thanks!