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