How to TRIM the naming convention 2

[bgibsonIYD]

I have a form, with a tab control, with a list box. In the row source of the list box I have the following code:

SELECT [Name] FROM msysobjects WHERE ((([msysobjects].[Type])=-32764)) AND ((Left([name],3)="lst&quot);

This code is to pull up all my reports that have the prefix "lst". Now I need to get rid of the prefix because I dont want that to show in the list box. How do I do this?

Beth Beth
**Learning Access**

 

[mymou]

will this do?

SELECT Right([name],Len([Name])-3) AS NameWithoutList
FROM msysobjects
WHERE (((msysobjects.Type)=-32764) AND ((Left([name],3))="lst&quot);

 

[bgibsonIYD]

Thank you! It worked!

Beth
**Learning Access**