Ignore first 4 characters in query result 1

[johnfrani]

In Access 2007, I named my training reports like this..."(t) All Training" and I named my personnel reports like this..."(p) All Employees" so my SELECT query could easily select either training or personnel reports.
I use this query to populate a listbox of personnel reports...

SELECT [MsysObjects].[Name], [MsysObjects].[Name]
FROM MsysObjects
WHERE ((([MsysObjects].[Name]) Not Like "~*"
And ([MsysObjects].[Name]) Not Like "MSys*")
And (([MsysObjects].[Name]) Like "(p)*")
And (([MsysObjects].[Type])=-32764))
ORDER BY [MsysObjects].[Name];

My problem is that I don't want the first 4 characters of the report name, the "(p) ", to display in the listbox.

How do I only display the "All Employees" part of the report name without the "(p) "?

Thanks, John

 

[MajP]

Select Mid([MsysObjects].[Name],4) as CleanName....

 

[johnfrani]

Thanks for your quick and excellent response. It worked like a charm.
John