sharkchaser
Technical User
I'm quite ingnorant regarding aggregate SQL functions, especially Count functions.
This query returns values that I can then count but what I would like is the query to actually COUNT the number of ListingDate and PendingDates that are returned for each.
Thanks . . . Rick
This query returns values that I can then count but what I would like is the query to actually COUNT the number of ListingDate and PendingDates that are returned for each.
Code:
SELECT June2010Newsletter.City, June2010Newsletter.ListingDate, June2010Newsletter.PendingDate
FROM June2010Newsletter
WHERE (((June2010Newsletter.City)="laguna woods") AND ((June2010Newsletter.ListingDate)>=#3/1/2010# And (June2010Newsletter.ListingDate)<=#3/31/2010#)) OR (((June2010Newsletter.City)="laguna woods") AND ((June2010Newsletter.PendingDate)>=#3/1/2010# And (June2010Newsletter.PendingDate)<=#3/31/2010#));
Thanks . . . Rick