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
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