Access query help

[Brandon Taylor]

Hi everyone,

I need to modify this query from SQL Server for use in Access. Can someone
please help me?!

SELECT DISTINCT TOP 100 PERCENT YEAR(CEDate) AS CEYear
FROM dbo.CurrentEvents
WHERE (CEDate < DATEADD(D, - 29, GETDATE()))
ORDER BY CEYear DESC

This select statement retrieves all dates older than 29 days from today, but
I'm having some trouble getting this to work in Access.

Many thanks in advance for your time,
Brandon

[Brandon Taylor]

Got it. Here's the SQL:

SELECT DISTINCT TOP 100 PERCENT DatePart("YYYY",EndDate) AS ArchiveYears
FROM Events
WHERE EndDate < DateAdd("D",-29,Date())

"Brandon Taylor" <bt@btaylordesign.com> wrote in message
news:d0vnns$518$1@forums.macromedia.com...

> Hi everyone,
>
> I need to modify this query from SQL Server for use in Access. Can someone
> please help me?!
>
> SELECT DISTINCT TOP 100 PERCENT YEAR(CEDate) AS CEYear
> FROM dbo.CurrentEvents
> WHERE (CEDate < DATEADD(D, - 29, GETDATE()))
> ORDER BY CEYear DESC
>
> This select statement retrieves all dates older than 29 days from today,
> but I'm having some trouble getting this to work in Access.
>
> Many thanks in advance for your time,
> Brandon
>