Help with LEFT Function

[NATASHA]

Hello,

I have a report that I group according to the first 4
prefix characters. For example, CONV 30 yr CONV 15yr FHA
15yr, So that I can get a total for all CONV and FHA.
Using grouping, I'm able to get the total for those
catergories. However, When I use the following for the
heading, I get an #Error!

=Left([Loan Type],4)

Any suggestions?

 

[Guest]

-----Original Message-----
Hello,

I have a report that I group according to the first 4
prefix characters. For example, CONV 30 yr CONV 15yr FHA
15yr, So that I can get a total for all CONV and FHA.
Using grouping, I'm able to get the total for those
catergories. However, When I use the following for the
heading, I get an #Error!

=Left([Loan Type],4)

Any suggestions?
.

Never mind. I found a solution. Thanks!

 

[Tom Lake]

I have a report that I group according to the first 4

prefix characters. For example, CONV 30 yr CONV 15yr FHA
15yr, So that I can get a total for all CONV and FHA.
Using grouping, I'm able to get the total for those
catergories. However, When I use the following for the
heading, I get an #Error!

=Left([Loan Type],4)

Any suggestions?
.

Never mind. I found a solution. Thanks!

Did it involve renaming the box on your form to avoid conflict?

Tom Lake