S
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
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