Text String.

[cap.zadi]

Hey there,

I have sentence in note so in query i want to shorten this one like:

"There was a problem in the line # 2."

how we can shorten this by query and results shud be?

"there was problem"



thanks

zee

[Robeen]

I think you can do this if you use an IIF statement in your query.

For example, you could use something like this:
Select Field1, Field2, IIF([Note] = "There was a problem in the line # 2.", "there was problem", [Note]) AS ModifiedNote From TableName

I hope this helps!

[cap.zadi]

Hey, thanks but it is not imp every time noe shud be " There was a problem in Line # 2" can be some other text.

how to shorten the names in access?

Qasim ali hadier ali

so i just want to keep 1st two text like " qasim ali".

how?

[Robeen]

Select Field1, Field2, Left([CourseDescription],9) AS ModifiedNote From TableName