I have a database that has a field with the calculation below

Result Field = Case(Ad space booked = "DPS TA"; publication: :DPS Type Area Width; Ad space booked = "Full page TA"; publication::Page Type Area Width; Columns = 1; publication::Column 1; Columns = 2; publication::Column 2; Columns = 3; publication::Column 3; Columns = 4; publication::Column 4; Columns = 5; publication::Column 5; Columns = 6; publication::Column 6; Columns = 7; publication::Column 7; Columns = 8; publication::Column 8; Columns = 9; publication::Column 9; Columns = 10; publication::Column 10; Columns = 11; publication::Column 11; Columns = 12; publication::Column 12; Columns = 13; publication::Column 13; Columns = 14; publication::Column 14; Columns * 15;Columns)

This means that when when I choose the first few choices "DPS TA" etc I get the value of those fields in my resulting field. When I choose any number 1 to 15 I get the value of the fields "Columns 1" to "Columns 15" from a related database. I also have a setting that if I type any number bigger than 15 I get that value in my resulting field. My problem is this if I type in any number between 100 and 149 I get no result at all but as soon as I type 150 I get a result. I hope this is clear please reply if you would like clarification on this matter. Thanks beforehand for any help

Steve

[This message has been edited by LiveOak (edited March 17, 2001).]

It looks like you have Columns set up as a text field. Change it to a number field.

To BobWeaver

Thanks Bob for your help it was most appreciated.