I want to write a generic module that I can reference in calculated fields in my queries that will help me segment field values from a table.
In pseudo code it would be like:
if ([field] >= 0 and [field] < 1)
then ("0.000 - 1.000")
else if ([field] >= 1 and [field] < 2)
then ("1.000 to 1.999")
I could apply this module in any query by creating a calculated field and referencing the module.
However, in looking through the help files I cannot figure out the syntax for this.