L

#### Leslie Isaacs

I'm sure this should be simple - but can't seem to get it!

I need a query that takes various integer values (say 'monthnumber'), and

returns an integer (say 'period') between 1 and 12, according to the

following pattern:

'monthnumber' 1 returns 'period' 1

'monthnumber' 2 returns 'period' 2

'monthnumber' 3 returns 'period' 3

etc etc until

'monthnumber' 13 returns 'period' 1

'monthnumber' 14 returns 'period' 2

etc etc until

'monthnumber' 25 returns 'period' 1

'monthnumber' 26 returns 'period' 2

etc etc

i.e. 'period' must generally be the whole-number remainder after dividing

'monthnumber' by 12 - except if the remainder is zero, 'period' must be 12!

I've tried all the obvious ways, but can't get a single formula to do this.

I guess I could do it with some 'If' clauses, but that doesn't seem right.

Hope someone can help.

Many thanks

Les