Monthly Training Not Crossing Year

[wreded]

Hi,
i've just discovered i have a problem. i have to track training and have a query that tracks training, by month. i just discovered that it won't show any training that is due in January. i assume that it's because it crosses an annual "boundary" of some kind. If i remove the field from my query everything else shows so i'm just going to show the part that doesn't work:
CODE
Field: Month([TestDate])
Table:
Sort:
Show: No
Criteria: Month(Date())+1
ENDCODE

Help! Before January comes!
Thanks,
Dave

 

[PHV]

Criteria: 1+(Month(Date()) Mod 12)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wreded]

Ding! Ding! Ding!
Thanks PHV! Worked like a charm.
Now the real question is; "Why didn't i think of that?"
Thanks,
Dave