I have a website for a realtor with an Access Database on one of the pages i have details for the property. On this page I have one Field that I would like not to show up if there is no information in that.

Example. I have a field for a Virtual Tour. If the property has a Virtual Tour I want a link to that tour to show up on the page.

But if the property does not have anything in that field meaning there is no Virtual Tour and I want the Virtual Tour to NOT show up..

How do I do this..

Thanks in advance.

Are you using ASP or PHP to query your database?

OK I have solved that problem but now I have another one.

I have a field which I am posting on a web. The Field is Virtual Tour.

I don't want it to show the actual data from the field, I just want to show the Words Virtual Tour. and those words will link to the link that this field has in it.. example..

Field will have the following info.. http://virtualtour.com/davidjoe.htm

The website page with the link will only have the words.

Virtual Tour which will link to the above link..

How do I show That?

Thanks for your Help