combining a hyperlink and table data to form complete link HELP!!!

[Donald H.]

I am currently trying to develop a inventory database for my machine shop.
here is what I am trying to acheive...

I have a table with products, their stock numbers, reorder Level, and
quantity on hand. I want this table to display a hyperlink in a column
labeled Reorder, when the "quatity on hand value" is < or = "reorder level
value". the hyperlink is one i extracted from the addressbar of our online
stock system when i searched for a stock number, the stock system site
displays search results in the following format:
"http://www.website.com/extension/searched/Flis_Summary.asp?FNiin={9 digit
stock number}"

This is a generic representation of what it actual is but the
"Flis_Summary.asp?FNiin={9 digit stock number}" portion is how its displayed
with the bracketed area actually being a 9 digit number.
Now what i want to do, and i guess this would be done in a query, is
basically have:

If (qty on hand) <= (reorder level) then
(http://www.website.com/extension/searched/Flis_Summary.asp?FNiin={here i
want to have it pull the table data from the column "stock number" which
contains the 9 digit stock number needed to complete the url"}) else {here im
kinda lost, but what i want is if the (qty on hand) > (reorder level) then i
just either dont want to display the link, or i want to display something
like "In Stock" thats all}

I'm using the "hyperlinkpart" expression for my hyperlink by the way, is
this the best way to get what im looking for?

I know this may seem very jumbled and confusing. Maybe this different
example will help:
Lets say Im using google instead and this is my goal.
To have the table display the link for the page for a google search of a
single word
In order to do this i google the word bird and get the url:
http://www.google.com/search?hl=en&q=bird
I use the following url in my query/form/code (still dont know where this is
best used):
"http://www.google.com/search?hl=en&q="
I want to use this url together with tabledata containing single words that
will be added on to the end of the above url to display the google search
page for that word. How do i do this in an if then format?
if x is <= y then http://www.google.com/search?hl=en&q={value from table
column with single words, i.e.-bird, dog, cat} else {display the word "none"}

So, if x in the first row is less than y in the first row, and cat is the
word in the first row a hyperlink should appear in the "link" column to
"http://www.google.com/search?hl=en&q=cat" but if x > y the link column
displays "none"


PLEASE HELP ME, I really want to figure this out but im at my wits end, i
tried the following as query criteria:


"IIf ( [Products]![QtyOnHand]<=[Products]![ReorderLevel] , HyperlinkPart
(Reorder#http://haystack.ihserc.com/code/Flis_Summary.asp?FNiin=[Products]![Stock Number]) , Good )"
And I got "The expression you have entered is a function with the wrong
number of arguments."
and got stuck.

and tried:
"If " [Products]![QtyOnHand]<=[Products]![ReorderLevel] Then "HyperlinkPart
(Reorder#http://haystack.ihserc.com/code/Flis_Summary.asp?FNiin=[Products]![Stock
Number]#, 0)" else if ( [Products]![QtyOnHand] > [Products]![ReorderLevel] )
then (Good)
End If"
And i got "you may have entered an operand with out an operator" and it
highlights the word 'Then' and I'm stuck.



HELP PLEASE!! My email is (e-mail address removed) if you can help please
let me know!!

 

[Fred]

I noticed that nobody answered

Only 5% of your post was about what you are trying to do, the rest was a lot
of stuff about possible ways to do it and analogies of ways to do it. As a
result, I can't tell what you are trying to do. You might want to repost,
and if you force yourself to leave out the databases lingo and goog
analogies, you'll probably force yourself to realy describe what you are
trying to do.

Are you just trying to display that conditional URL, or is "hyperlink" your
way of saying that are you trying to make it so that if a person clicks on
that they will go to that web site page?

I am currently trying to develop a inventory database for my machine shop.
here is what I am trying to acheive...

I have a table with products, their stock numbers, reorder Level, and
quantity on hand. I want this table to display a hyperlink in a column
labeled Reorder, when the "quatity on hand value" is < or = "reorder level
value". the hyperlink is one i extracted from the addressbar of our online
stock system when i searched for a stock number, the stock system site
displays search results in the following format:
"http://www.website.com/extension/searched/Flis_Summary.asp?FNiin={9 digit
stock number}"

This is a generic representation of what it actual is but the
"Flis_Summary.asp?FNiin={9 digit stock number}" portion is how its displayed
with the bracketed area actually being a 9 digit number.
Now what i want to do, and i guess this would be done in a query, is
basically have:

If (qty on hand) <= (reorder level) then
(http://www.website.com/extension/searched/Flis_Summary.asp?FNiin={here i
want to have it pull the table data from the column "stock number" which
contains the 9 digit stock number needed to complete the url"}) else {here im
kinda lost, but what i want is if the (qty on hand) > (reorder level) then i
just either dont want to display the link, or i want to display something
like "In Stock" thats all}

I'm using the "hyperlinkpart" expression for my hyperlink by the way, is
this the best way to get what im looking for?

I know this may seem very jumbled and confusing. Maybe this different
example will help:
Lets say Im using google instead and this is my goal.
To have the table display the link for the page for a google search of a
single word
In order to do this i google the word bird and get the url:
http://www.google.com/search?hl=en&q=bird
I use the following url in my query/form/code (still dont know where this is
best used):
"http://www.google.com/search?hl=en&q="
I want to use this url together with tabledata containing single words that
will be added on to the end of the above url to display the google search
page for that word. How do i do this in an if then format?
if x is <= y then http://www.google.com/search?hl=en&q={value from table
column with single words, i.e.-bird, dog, cat} else {display the word "none"}

So, if x in the first row is less than y in the first row, and cat is the
word in the first row a hyperlink should appear in the "link" column to
"http://www.google.com/search?hl=en&q=cat" but if x > y the link column
displays "none"


PLEASE HELP ME, I really want to figure this out but im at my wits end, i
tried the following as query criteria:


"IIf ( [Products]![QtyOnHand]<=[Products]![ReorderLevel] , HyperlinkPart
(Reorder#http://haystack.ihserc.com/code/Flis_Summary.asp?FNiin=[Products]![Stock Number]) , Good )"
And I got "The expression you have entered is a function with the wrong
number of arguments."
and got stuck.

and tried:
"If " [Products]![QtyOnHand]<=[Products]![ReorderLevel] Then "HyperlinkPart
(Reorder#http://haystack.ihserc.com/code/Flis_Summary.asp?FNiin=[Products]![Stock
Number]#, 0)" else if ( [Products]![QtyOnHand] > [Products]![ReorderLevel] )
then (Good)
End If"
And i got "you may have entered an operand with out an operator" and it
highlights the word 'Then' and I'm stuck.



HELP PLEASE!! My email is (e-mail address removed) if you can help please
let me know!!