Ok, I am new to this. I am displaying data from a access database on a
page. I am using the DRW to retrieve data based on criteria. What I can't
seem to do is display a different value for a field based on a specific
value. i.e. - I want to display the email addresses if PubEmail = 'Yes',
but display "non-published" if PubEmail is 'No'.

I have tried to add a SQL statement to Custom Query, but everything I try
results in an error.

I appreciate any/all help.

See the answer to your previous post.

--
~ 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" <Susan (E-Mail Removed)> wrote in message
news:035E2EEA-310E-42DC-AA88-(E-Mail Removed)...
> Ok, I am new to this. I am displaying data from a access database on a
> page. I am using the DRW to retrieve data based on criteria. What I
> can't
> seem to do is display a different value for a field based on a specific
> value. i.e. - I want to display the email addresses if PubEmail = 'Yes',
> but display "non-published" if PubEmail is 'No'.
>
> I have tried to add a SQL statement to Custom Query, but everything I try
> results in an error.
>
> I appreciate any/all help.
>

I can't find my prior post - please help!

"Kathleen Anderson [MVP - FrontPage]" wrote:

> See the answer to your previous post.
>
> --
> ~ 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" <Susan (E-Mail Removed)> wrote in message
> news:035E2EEA-310E-42DC-AA88-(E-Mail Removed)...
> > Ok, I am new to this. I am displaying data from a access database on a
> > page. I am using the DRW to retrieve data based on criteria. What I
> > can't
> > seem to do is display a different value for a field based on a specific
> > value. i.e. - I want to display the email addresses if PubEmail = 'Yes',
> > but display "non-published" if PubEmail is 'No'.
> >
> > I have tried to add a SQL statement to Custom Query, but everything I try
> > results in an error.
> >
> > I appreciate any/all help.
> >
>
>
>

http://www.microsoft.com/office/comm...0-83cf43ce8d16

--
~ 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:3E266699-125D-48DF-B6D6-(E-Mail Removed)...
>I can't find my prior post - please help!
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> See the answer to your previous post.
>>
>> --
>> ~ 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" <Susan (E-Mail Removed)> wrote in message
>> news:035E2EEA-310E-42DC-AA88-(E-Mail Removed)...
>> > Ok, I am new to this. I am displaying data from a access database on
>> > a
>> > page. I am using the DRW to retrieve data based on criteria. What I
>> > can't
>> > seem to do is display a different value for a field based on a specific
>> > value. i.e. - I want to display the email addresses if PubEmail =
>> > 'Yes',
>> > but display "non-published" if PubEmail is 'No'.
>> >
>> > I have tried to add a SQL statement to Custom Query, but everything I
>> > try
>> > results in an error.
>> >
>> > I appreciate any/all help.
>> >
>>
>>
>>

Hi,

The SQL would be (I'm assuming Access here)

SELECT Field1, Field2, IIF(PubEmail='Yes', EmailAddressField, 'Not
Published') AS EmailAddress
FROM YourTable

Just change the field/table names to suit and enter this as a Custom Query -
wizard step 2.

Jon

"Susan G" <Susan (E-Mail Removed)> wrote in message
news:035E2EEA-310E-42DC-AA88-(E-Mail Removed)...
> Ok, I am new to this. I am displaying data from a access database on a
> page. I am using the DRW to retrieve data based on criteria. What I
> can't
> seem to do is display a different value for a field based on a specific
> value. i.e. - I want to display the email addresses if PubEmail = 'Yes',
> but display "non-published" if PubEmail is 'No'.
>
> I have tried to add a SQL statement to Custom Query, but everything I try
> results in an error.
>
> I appreciate any/all help.
>

If the PubEmail is a Yes/No field, then you have to test for it using:

<If rs("PubEmail") = YES Then %><a href="mailto:<%=rs("Email")%>"><%=rs("Email")%></a><% Else
%>non-published<% End If %>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Susan G" <Susan (E-Mail Removed)> wrote in message
news:035E2EEA-310E-42DC-AA88-(E-Mail Removed)...
> Ok, I am new to this. I am displaying data from a access database on a
> page. I am using the DRW to retrieve data based on criteria. What I can't
> seem to do is display a different value for a field based on a specific
> value. i.e. - I want to display the email addresses if PubEmail = 'Yes',
> but display "non-published" if PubEmail is 'No'.
>
> I have tried to add a SQL statement to Custom Query, but everything I try
> results in an error.
>
> I appreciate any/all help.
>