FN-FORUM: More SQL Help

date posted 12th January 2007 16:15

Hi

I've got this working on a page =85

strSQL1 =3D "SELECT l.LicenseeID, l.Company, l.FirstName, l.LastName,
l.EmailAddress, count(*) AS NumScores FROM tblScores AS s INNER JOIN
tblGroups AS g ON s.GroupID =3D g.GroupID INNER JOIN tblLicensees AS l
ON g.LicenseeID =3D l.LicenseeID WHERE s.GeneratedDate >=3D '" &
strFormattedStartDate & "' AND s.GeneratedDate