I have been working on this for two days with no
success. I want to display database results, but want to
change the value of the display if a field result is No.
Example: I want to display email addresses if the user
has indicated 'Yes' in Publish Email field, but want
display "non-published" if the field value is 'No'.

Where do I do this - in Custom Query or somewhere else?
Ever

You can wrap the DatabaseResultsColumn in some script; here's a prior post
with an example:
http://www.microsoft.com/office/comm...e01&sloc=en-us

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



"Susan" <(E-Mail Removed)> wrote in message
news:1e6001c50151$366dee40$(E-Mail Removed)...
>I have been working on this for two days with no
> success. I want to display database results, but want to
> change the value of the display if a field result is No.
> Example: I want to display email addresses if the user
> has indicated 'Yes' in Publish Email field, but want
> display "non-published" if the field value is 'No'.
>
> Where do I do this - in Custom Query or somewhere else?
> Ever

when you say "wrap the DatabaseResultsColumn in some script" what do you mean?

Where do I put this script?

Susan:
Please include the text of the post you are replying to.

Re: wrapping the DatabaseColumnResults field in script - you would do this
in HTML/Code view. Find the code where the fields that you want to work with
are displayed.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



"Susan G" <(E-Mail Removed)> wrote in message
news:74E4A159-FC2D-4B70-BBE1-(E-Mail Removed)...
>
> when you say "wrap the DatabaseResultsColumn in some script" what do you
> mean?
>
> Where do I put this script?