SELECT CodeValue, CodeDesc FROM Lookups WHERE CodeGroup = 'MONTH' ORDER BY CodeValue SELECT CodeValue, CodeDesc FROM Lookups WHERE CodeGroup = 'YEAR' AND CodeValue >= '#Year(now())#' ORDER BY CodeValue SELECT TOP 10 EventID, EventName, BeginDate From Events WHERE BeginDate >= #CreateODBCDate(DateFormat(now(), 'm/d/yyyy'))# AND Canceled = 0 AND SiteID = 1 AND DateApproved is not NULL ORDER BY BeginDate, EndDate SELECT Province, ProvinceName From Province ORDER BY Province SELECT * From Lookups WHERE CodeGroup = 'AUDIENCE' AND CodeValue <> 'X' ORDER BY CodeValue SELECT * From Lookups WHERE CodeGroup = 'EVENT' ORDER BY CodeValue SELECT * From SubSites WHERE SiteID = 1 Episcopal Calendar
#DateFormat(BeginDate, "m/d/yyyy")#: #EventName#