B
Bob Vance
How can you I select records between StartDate and EndDate in my query
below
SELECT tblRemarks.HorseID, tblRemarks.Category, Max(tblRemarks.RemarkID) AS
RemarkID1, tblHorseInfo.Status, tblRemarks.dtDate,
tblHorseManagement.StartDate, tblHorseManagement.EndDate
FROM tblHorseManagement, tblRemarks INNER JOIN tblHorseInfo ON
tblRemarks.HorseID = tblHorseInfo.HorseID
GROUP BY tblRemarks.HorseID, tblRemarks.Category, tblHorseInfo.Status,
tblRemarks.dtDate, tblHorseManagement.StartDate, tblHorseManagement.EndDate
HAVING (((tblHorseInfo.Status) Like 'Active*'));
below
SELECT tblRemarks.HorseID, tblRemarks.Category, Max(tblRemarks.RemarkID) AS
RemarkID1, tblHorseInfo.Status, tblRemarks.dtDate,
tblHorseManagement.StartDate, tblHorseManagement.EndDate
FROM tblHorseManagement, tblRemarks INNER JOIN tblHorseInfo ON
tblRemarks.HorseID = tblHorseInfo.HorseID
GROUP BY tblRemarks.HorseID, tblRemarks.Category, tblHorseInfo.Status,
tblRemarks.dtDate, tblHorseManagement.StartDate, tblHorseManagement.EndDate
HAVING (((tblHorseInfo.Status) Like 'Active*'));