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

You can create a new field in your query like this:

MyNewFieldName:""http://www.mydomain.co.uk/details.asp?productID=" & [ProductIDFieldNameHereInSquareBrackets]