Create a Query on a Hyperlink

[Gamesetal]

Have '97 and am trying to create a query on the underlying Hyperlink
field - ie if xxx then else ...
Can't find a way to do this and would very much appreciate some kind
help - thanks - John

[Douglas J. Steele]

Not sure I understand your example. Can you explain what xxx is supposed to
be?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Gamesetal" <in**@gamesetal.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Have '97 and am trying to create a query on the underlying Hyperlink
field - ie if xxx then else ...
Can't find a way to do this and would very much appreciate some kind
help - thanks - John

[Gamesetal]

Sorry - that wasn't too helpful of me - The hyperlink field will have a
legend in a search, form or table - the hyperlink under this -
activated when clicked upon - is what I want to search on - that could
be a link to a variety of web pages - I can't seem to query at the
hyperlink depth just the field image - God am I making this any
clearer? - so if Hyperlink = www.xxx.com then show in the query results
[ criteria = www.xxx.com ] - honestly this has nothing to do with sex
sites ;~)
Hope this explains my problem.

[Salad]

Gamesetal wrote:

Sorry - that wasn't too helpful of me - The hyperlink field will have a
legend in a search, form or table - the hyperlink under this -
activated when clicked upon - is what I want to search on - that could
be a link to a variety of web pages - I can't seem to query at the
hyperlink depth just the field image - God am I making this any
clearer? - so if Hyperlink = www.xxx.com then show in the query results
[ criteria = www.xxx.com ] - honestly this has nothing to do with sex
sites ;~)
Hope this explains my problem.

See HyperlinkPart in help. In VBA, you can use acAddress and acDisplay
in HyplerlinkPart. In a query, you need to use the value of acAddress
or acDisplay. To find the values, go to the Immediate/Debug window and
enter
? acDisplay
to get the value.

Now, if you break the hyperlink apart, clicking on that value in the
column will not execute a jump to the link. So you might have something
like
Select Hyperlink from Table Where HyperlinkPart(hl,2) = "www.xxx.com"

[Gamesetal]

Thanks for that but I am a layman and don't know a thing about VBA??? -
can I do this at the Access Query Level without resorting to
programming?
TIA - John

[Gamesetal]

Thank you all - I have managed it at the Query level using
HyperlinkPart and guessing [? sorry] at the part number... John