ALSO, I keep getting "operand types" in the message line. What does that mean? /b[/quote]Usually means you are trying to apply character related changes to a field (or using a field) defined as numeric or vice versa.
Operand count usually means the number of parentheses pairs need to be checked of there are missing parameters related to one or more functions in the formula that make it un-interpretable.
I get all of them all the time!
As for you main problem, are you creating a new calculated field which either containd the value of 'number' field or that value with something added to the prefix depending upon whther the 'amount' filed is above or below a certain value?
If so, where does the prefix come from and is it safe to assume that the resulting field is defined to be a character field? Is the 0 to be added to the beginning or the end of the prefix?
Is 'number' really a number or is it a character field?
Sorry for the questions but hope they help us clarify where the problem lies.
Thanks for the response. Now let me answer your questions.
I think you understood what I needed. I want to create a calculated column that if the invoice amount (in the "amount" column) is less than $2000.00, I want a zero added to the front of the invoice number (original invoice number is in the "number" column). If this condition is false, I want the calculated field to just hold the original invoice number.
The "number" column will be a character.
I hope this helps.
I was leaving "=1" out. I guess this means if the condition is true? /b[/quote]Correct.
You could write the formula the other way as well.
I have to admit it is quote easy to forget sometimes that the formula is looking for a 1 or 0 result from the comparison ...