Show past 3 years

[BerkshireGuy]

I need a query to include a field called SettlementDate.

When the user runs the query, I need to prompt for "Enter Year" and
show the last three years of SettlementDate.

Can seem to get the logic down.

Thanks

[Salad]

BerkshireGuy wrote:

I need a query to include a field called SettlementDate.

When the user runs the query, I need to prompt for "Enter Year" and
show the last three years of SettlementDate.

Can seem to get the logic down.

Thanks

I tried this SQL
SELECT ID, DateEntered, Year([DateEntered]) AS Expr1
FROM Table1
WHERE Year([DateEntered] Between [Enter Year] And [Enter Year]+2;

Seemed to work.

Dirty
http://www.youtube.com/watch?v=JjQ4SmptIyQ

[BerkshireGuy]

Thanks - I was just going to post that I did:

SQL Select Year(SettlementDecisionDT) ...... ....
FROM Mytable
Where
Year([SettlementDecisionDT]))>=[Enter Year]-3));

So basic. Coffee hadn't kicked in. :)

Thanks

On Mar 24, 11:12*am, Salad <[e-mail]:

BerkshireGuy wrote:

I need a query to include a field called SettlementDate.

When the user runs the query, I need to prompt for "Enter Year" and
show the last three years of SettlementDate.

Can seem to get the logic down.

Thanks

I tried this SQL
SELECT ID, DateEntered, Year([DateEntered]) AS Expr1
FROM Table1
WHERE Year([DateEntered] Between [Enter Year] And [Enter Year]+2;

Seemed to work.

Dirtyhttp://www.youtube.com/watch?v=JjQ4SmptIyQ

[Bob Quintal]

BerkshireGuy <be*************************@yahoo.comwrote in
news:13b0ebce-7c2f-452e-9eb6-
60**********@t54g2000hsg.googlegroups.co
m:

Thanks - I was just going to post that I did:

SQL Select Year(SettlementDecisionDT) ...... ....
FROM Mytable
Where
Year([SettlementDecisionDT]))>=[Enter Year]-3));

So basic. Coffee hadn't kicked in. :)

It won't work when you enter a date 4 or more years ago. You'll get
the three years you want plus all the more recent data

>
Thanks

On Mar 24, 11:12*am, Salad <[e-mail]:

>BerkshireGuy wrote:

I need a query to include a field called SettlementDate.

When the user runs the query, I need to prompt for "Enter Year"
and show the last three years of SettlementDate.

Can seem to get the logic down.

Thanks

I tried this SQL
SELECT ID, DateEntered, Year([DateEntered]) AS Expr1
FROM Table1
WHERE Year([DateEntered] Between [Enter Year] And [Enter Year]+2;

Seemed to work.

Dirtyhttp://www.youtube.com/watch?v=JjQ4SmptIyQ

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com