IFF and Dates in query

[pazgb]

I need to pull the records using our companies fiscal year calander. What i did was made a table by months with the startdate and enddate. example below

tblFiscalPer

AutoID PerID StartDate EndDate
1 1 12/29/2002 2/ 1/2003
2 2 2/ 2/2003 3/ 1/2003
3 3 3/ 2/2003 3/29/2003
4 4 3/30/2003 5/ 3/2003
5 5 5/ 4/2003 5/31/2003
6 6 6/ 1/2003 6/28/2003
7 7 6/29/2003 8/ 2/2003
8 8 8/ 3/2003 8/30/2003
9 9 8/31/2003 9/27/2003
10 10 9/28/2003 11/ 1/2003
11 11 11/ 2/2003 11/29/2003
12 12 11/30/2003 1/ 3/2004
13 1 1/ 4/2004 2/ 7/2004
14 2 2/ 8/2004 3/ 6/2004
15 3 3/ 7/2004 4/ 3/2004
16 4 4/ 4/2004 5/ 8/2004
17 5 5/ 9/2004 6/ 5/2004
18 6 6/ 6/2004 7/ 3/2004
19 7 7/ 4/2004 8/ 7/2004
20 8 8/ 8/2004 9/ 4/2004
21 9 9/ 5/2004 10/ 2/2004
22 10 10/ 3/2004 11/ 6/2004
23 11 11/ 7/2004 12/ 4/2004
24 12 12/ 5/2004 1/ 1/2005


What i need is to get the current date and find the date range and pull all the records from in between that date range.

I need the query criteria.

Can anyone help?

Thanks,
Mike

 

[DanChard]

Try something like:

where startdate < now() < end_date

Should do the trick!

 

[cottontop]

Field: DateDiff(&quot;d&quot;, now(), [startdate])
Criteria: >0