Query

[crcastilla]

I want to run a query that shows the Due Dates that are coming up in the next two weeks (the start point would be the current time) So if I run a query today, 8/23/2011 then I would have to see the due dates between 8/23/2011 and 9/06/2011. Is this possible? what would the expression be?

 

[John Big Booty]

You could use the following as the criteria in your query;

Between [URL="http://www.techonthenet.com/access/functions/date/date.php"]Date()[/URL] And [URL="http://www.techonthenet.com/access/functions/date/dateadd.php"]DateAdd[/URL]("ww", 2, Date())