Date Formula Needed

[Santi]

I’m trying to create an Access formula that when I do a query it will only
show me effective dates until about two months in advance and beyond. Can
anyone help me?


Example:


Table 1 Starting Date Ending Date

MA FAIR 8/30/08 9/2/08
NY FAIR 6/30/08 7/5/08
FL FAIR 9/6/08
CA FAIR 4/5/08 4/10/08
IL FAIR 8/1/08
ID FAIR 2/108 2/25/08

I need an Access formula that when I run a query it will give me all ending
dates that haven’t expired including the records which have no ending date.

The result from the example above should be something like this:


MA FAIR 8/30/08 9/2/08
NY FAIR 6/30/08 7/5/08
FL FAIR 9/6/08
IL FAIR 8/1/08

 

[Jerry Whittle]

SELECT Santi.[Table 1],
Santi.[Starting Date],
Santi.[Ending Date]
FROM Santi
WHERE Santi.[Ending Date]>Date()
Or Santi.[Ending Date] Is Null;

You need to put in the proper table and field names.

In a put the following in the Criteria under the Ending Date field: