RE: SQL Repeated Number Query

2003-06-30 Thread Josh Remus
Thank you Jochem, I knew it had to be possible! I didn't think to link the table to itself. Josh > -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 11:43 AM > To: CF-Talk > Subject: Re: SQL Repeated Number Query &g

Re: SQL Repeated Number Query

2003-06-30 Thread Jochem van Dieten
Josh Remus wrote: > > I have a RA database which tracks incoming returns and service performed on > those units. That table (RA) contains a SerialNumber and a CreateDate/Time > stamp. What I need is SQL that will check if there is more than one entry > for a particular serial number in a 90-day