Inspect a Hyperlink field address to determine target file type

[Guest]

All,

I have a table in Access that it linked to a SharePoint Database. There is
a field in that table that is a hyperlink field. The hyperlinks all use
display names and point to other documents in the portal. I need to be able
to exclude all rows where the hyperlink target address is a .pvw file in my
query, but I can't get that to work.
Any ideas?

Thanks.

 

[Brendan Reynolds]

SELECT tblTest.TestURL
FROM tblTest
WHERE (((tblTest.TestURL) Not Like "*.pvw*"));

The only problem I see with the above is that if you had a file name
something like "somefile.pvw.txt" it would be excluded too. I can't think of
a solution to that other than avoiding more than one "." character in a file
name.