Here's the sql that works
Code:
SELECT dbo_tbl_Adv_Source.AdvSource, dbo_tbl_Adv_type.Adv_Type, dbo_tbl_Adv_Schedule.Adv_RunDate
FROM (dbo_tbl_Adv_Schedule INNER JOIN dbo_tbl_Adv_type ON dbo_tbl_Adv_Schedule.adv_TypeID = dbo_tbl_Adv_type.Adv_TypeID)
INNER JOIN dbo_tbl_Adv_Source ON dbo_tbl_Adv_Schedule.Adv_SourceID = dbo_tbl_Adv_Source.AdvSourceID
WHERE (((dbo_tbl_Adv_Schedule.Adv_SchedID) = 1))
GROUP BY dbo_tbl_Adv_Source.AdvSource, dbo_tbl_Adv_type.Adv_Type, dbo_tbl_Adv_Schedule.Adv_RunDate;
Other than adding the group by and reordering the From clause I don't really see much of a difference.