I really didn't get an answer from anyone that helped me with the date range question. Could anyone please take a look at it again for me?
I have written a simple query that works just fine; however, I need to add a date range filter, like this: WHERE PostedCards.PostDate Between #10/1/2007# And #11/30/2007# and I already have a WHERE clause and don't know where to put this one or the proper syntax I've attached my complete query, could someone please help me with this, Thanks so much. Bud Here tis: SELECT DISTINCTROW PostedCards.ClinicID, PostedCards.Client, PostedCards.PetNumber, PostedCards.PetName, PostedCards.VacDesc1, PostedCards.VacDue1, PostedCards.VacDue2, PostedCards.VacDue3, PostedCards.VacDue4, PostedCards.VacDue5, PostedCards.ClinicAddress1, PostedCards.ClientName, PostedCards.PetCardDate, PostedCards.PostDate FROM PostedCards WHERE (((PostedCards.ClinicID) In (SELECT [ClinicID] FROM [PostedCards] As Tmp and GROUP BY [ClinicID], [Client], [PetNumber], [PetName], [VacDesc1], [VacDue1], [VacDue2], [VacDue3], [VacDue4], [VacDue5] HAVING Count(*)>1 And [Client] = [PostedCards].[Client] And [PetNumber] = [PostedCards].[PetNumber] And [PetName] = [PostedCards].[PetName] And [VacDesc1] = [PostedCards].[VacDesc1] And [VacDue1] = [PostedCards].[VacDue1] And [VacDue2] = [PostedCards].[VacDue2] And [VacDue3] = [PostedCards].[VacDue3] And [VacDue4] = [PostedCards].[VacDue4] And [VacDue5] = [PostedCards].[VacDue5]))) ORDER BY PostedCards.ClinicID, PostedCards.Client, PostedCards.PetNumber, Postedcards.petcarddate;
