6363 – programming note to self –

filename: Mid([Database_Location], InStrRev([Database_Location],””) +1)

from another Query ([Server_Names]):
dl (which is the Database location full path)
Server name
Share name

SELECT [Server_Names].[Server Name], [Server_Names].[Share Name],
Mid([dl],InStrRev([dl],””)+1) AS [FN]
FROM [Server_Names]
ORDER BY [Server_Names].[Share Name];

=====

Related Posts

Leave a Reply