Results 1 to 2 of 2

Thread: Access Query! - Is this possible

  1. #1
    Join Date
    Sep 2009
    Posts
    1

    Access Query! - Is this possible

    Hi Folks -
    Could you advise if this is possible and if so, how to do it?
    I need to have a product url in my query, but my database does not include this.
    The url's are created in ASP using the productID.
    Is there a way to have a standard url and append the productID to the end?

    e.g. "http://www.mydomain.co.uk/details.asp?productID" and then append the productID from the database. It would then look like this. "http://www.mydomain.co.uk/details.asp?productID=123"

    Thanks in advance
    Andy

  2. #2
    Join Date
    Jan 2009
    Location
    Portland, Oregon
    Posts
    21
    You can create a new field in your query like this:

    MyNewFieldName:""http://www.mydomain.co.uk/details.asp?productID=" & [ProductIDFieldNameHereInSquareBrackets]
    Bob Larson
    Former Access MVP
    2008-2010

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •