Need your help in string modification...

[sabavno]

Hi,

I have this problem.
My list has a query as its source code. (For example: Select * from charges where AssetType = "Monitor"

You've noticed that there is a semi-colon that gets assigned at the end by Access 97 (there is not semi-colon at the end of the query's SQL in Access 2000)

I have a button on the form that sorts the first column

The code under this button is:

sql=List.RowSource

List.RowSourse = sql & " Order By Name"

That is where the problem with semi-colon comes in.

I get the following RowSource:
Select * from charges where AssetType = "Monitor"; Order by Name

How would I get rid of that semi-colon?

Please note that don't want to hardcode the SQL myself instead of using this line sql=List.RowSource.

Thanks.

 

[WayneRyan]

sabavno,

Use the Left function to truncate the sql variable by
one character.

Wayne

 

[JeremyNYC]

left(strYadda, len(strYadda) - 1), to be specific. =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.