Len() and Left()

[Rick4077]

If Left([FieldName) has no length, ie. 6, will it return the entire value of the field? . . . as a sting?

If Len() contains 23 chr will it return 23?

Thanks . . . Rick

 

[dhookom]

Left([FieldName)" won't work for a couple reasons:
[li]There are unbalanced []s[/li]
[li]Left() requires two arguements, not one[/li]
Why don't you try these expressions? Open the immediate window (Press Ctrl+G) and enter:

? Left("any expression",3)
? Len("any expression")

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Rick4077]

Will Left() work with Len() as a wildcard?

This code does not produce the correct results. I suspect it has something to do with the way Left() and Len() are reading the value of the fields.

Sum(IIf(Left(S.ListName,Len(C.OfcName))<>Left(S.SellName,Len(C.OfcName)),1,0)) AS TSO, Sum(IIf(Left(S.ListName,Len(C.OfcName))<>Left(S.SellName,Len(C.OfcName)),S.SalePrice,0)) AS TSODV,

Thanks much.

Rick

 

[dhookom]

It would help if you provided some sample data and the results. I don't necessarily see anything wrong with the expressions. You might also explain what/why you are doing.

We can't see your data or your results or why you think "code does not produce the correct results".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]