Help with LEFT Function

  • Thread starter Thread starter NATASHA
  • Start date Start date
N

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?
 
-----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?
.
Click to expand...

Never mind. I found a solution. Thanks!
 
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?
.
Click to expand...

Never mind. I found a solution. Thanks!
Click to expand...

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

Tom Lake
 
Back
Top