Hyperlink searching

[Guest]

I have a field on a table which is a hyperlink to a folder on our system, I
want to run a query that only selects certain submissions that have this
hyperlink in a certain folder ie

archive/folder1/ - I want it to find these
business/folder2/ - I dont want to find these.

i thought I might be able to add the field to a query and use the criteria
to specify the first part of the link 'archive' but it doesn't find anything,
are there hot keys or anything i could use in the query criteria so access
doesn;t matter whats after the initial match for 'archive'.

Any ideas anyone, thanks

 

[Douglas J Steele]

Use

Like "*archive/*"

as your criteria.

(I believe the first asterisk is necessary, as I suspect you've got
information in front of the folder name. If you don't, try it without that
first asterisk)