formula question

[smiley0q0]

I have a little experience with access, but i don't know what this formula means, particularly the "In" part. can anybody explain what this is supposedly doing...
(this is in a query)

month: IIf(Month([CycleYearly_tbl]![Date])+1 In (1,2,3,4,5,6,7,8,9,10,11,12),Month([CycleYearly_tbl]![Date])+1,1)

the CycleYearly_tbl has a column of months and dates, the dates column is in sequential order, but there are only an average of 12 dates per month. if you need more explaination, let me know and i'll try to see what i can do.

Thanks.
Smiley :-D

 

[Vika]

In this case In means any of the following. The formula reads:
If Month([CycleYearly_tbl]![Date])+1 equals any of the following then ...
Does it makes more sense?

 

[smiley0q0]

yea, that makes a lot more sense than i was making out of it.

Thank you.