BEST DOG TRAINING BOOK

I need Access Help — I have a table with a column of names and a column of URL’s – how can i make a query…

I have a table with a column of Names and column of URL’s.

How can i make a query return just one column, which will give me the names, and have the urls embedded in the name.

Example:

*Table*
1 Dog—-www.dog.com
2 Cat—-www.cat.com
3 Bird—-www.bird.com

*Query*
Dog (with a link to www.dog.com)
Cat (linked to www.cat.com)
Bird (linked to www.bird.com)

All of this is to make a webpage that has a column of links. Is there an easier way or is there even a way to do what i’m trying to do?

Thanks!

I think ‘tancy2411′ may have misunderstood your question.

Unlike Excel, Access stores your information as plain text without any formatting. This means your query cannot display text with an URL embedded in it. You can probably make links show up on a form or report (I’ve never done it, but I don’t see why you can’t)–and Access seems to have a feature to make web pages automatically (which I’ve never used, so I couldn’t tell you how to use it)–but considering your purpose, I don’t really think that’s necessary (in fact, making a form or report with links may not help you make a webpage at all).

Instead, you can make a query that writes the HTML for your webpage (or at least some of it) automatically. Try copying something like this into ‘SQL View’ of a new query:

SELECT ‘‘ + [Name] + ‘
‘ AS Output FROM TableName;

Replace ‘URL’ with the name of the field (column) in your table that holds the URLs (leave the brackets around it), ‘Name’ with the name of the field that holds the site’s names, and ‘TableName’ with the name of your table. You could also change ‘Output’ to something else, but it shouldn’t really matter.

Then save the query (name it whatever you want) –> go to ‘File’ –> click ‘Export…’ –> browse to where you want to put it –> put whatever you want in ‘File name:’, as long as it ends in ‘.htm’ or ‘.html’ –> in the drop down list next to ‘Save as type:’, select ‘Text Files (*.txt;*.csv;*.tab;*.asc)’ –> click ‘Export’ –> make sure the top option (‘Delimited’) is selected –> click ‘Next >’ –> choose ‘Space’ as the delimiter –> make sure ‘Include Field Names…’ is unchecked –> in the drop down list next to ‘Text Qualifier:’, select ‘{None}’ –> click ‘Next >’ –> click ‘Finish’ –> click ‘OK’.

Now you should be able to open the file you created in your web browser and click on the links. Of course, if you’re not a big fan of very simple webpages, you can always edit the file to suit your needs (probably should at least add , ,