Steven, take a look at the SQL Statement below
SELECT [Name] FROM MSysObjects WHERE [Type]=-32768 And Not (Left([Name],1)="~" Or Left([Name],6)="sysfrm") ORDER BY [Name];
That is just an example of an SQL Statement I already have in one of my databases. I need some guidance regarding changing the SQL statement so it will show all reports in the database (not including system reports).
Now here's the thing. I talked to Greg via AOL Instant Messenger last night and he said he uses the "rpt" prefix for reports. Building on that, I decided that I should use the prefix "sysrpt"
Any further help would be appreciated.
Madison Area Technical College student
"There are two kinds of people in the world: Those who claim to be Flash junkies and those who actually are Flash junkies"