Re: Formula Question

try this (the syntax is probably not correct):

SELECT *  FROM table WHERE

((table.year * 12) + table.period - 12) = ((target.year * 12) + target.period))

I assume that there are 12 period in a year

This formula works and can be adapted to compute any period (you can just 
substract a different value than 12)

Denis Robitaille
Directeur services technique TI
819 363 6130

SUPPORT
Jour (EST) Daytime : 819-363-6134
En-dehors des heures (EST) After hour : 819-363-6158
Network Status : 819-363-6157

>>> koldark@xxxxxxxxx 2006-01-04 18:31:53 >>>
Okay, this may be a difficult one. I have a simple table layout like this.

Company (4,0)
Year(4,0)
Period(2,0)
Amount(15,2)

I want to be able to take an ending period and determine 12 months back from
the ending date and select records in the DB via a select statement. We are
really close with the following formula: ( ( ( (period-12) / (period-12) ) *
12 ) - 11 )+period. A co-worker of mine got this far. If it wasn't for the
whole divide by zero bit as this portion ( (period-12)/(period-12) ) would
for period 12, it would work great. Short of a case statement is there a
better way to handle divide by zero? Or is the a better formula that we
aren't seeing?

--
Mike Wills
koldark@xxxxxxxxx 
http://mikewills.name 
Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.

"There are 10 types of people in the world: those who understand binary, and
those who don't." -Unknown