Date & Repetition Query

[Fermats1980]

Hi. I am trying to run a query that will show me if a particular serial number has been duplicated within a specific timeframe. So, for example, if a serial number 123 occured in December 2012, I want to try and confirm if it occured within say two months of that date (plus or minus). Just to add some difficulty to the mix; I have experience with Access, but none with SQL (but can obviously cut & paste). Thank you in advance.

[June7]

Try:

SELECT *, DCount("SerNum","tablename","SerNum='" & [SerNum] & "' AND [datefield] Between #" & [datefield]-60 & "# And #" & [datefield]+60 & "#") As CountSN FROM tablename;