Hi All

Anyone know a way of not showing a record field if it is equal to a certain value.

I have several text fields which have n/a in them and would to the results page to ignore showing any field with this value.

Thanks in advance

CK

Try this:
of course use you recordset where says rsRecordset and your record field where it says Record.
<% If (rsRecordset.Fields.Item("Record".Value) <> "" Then %>
<%=(rsRecordset.Fields.Item("Record".Value)%>"
<% End If%>

Thank you for your reply,

How would I write this to exclude a static value of "n/a" found in the record ?

Doh, figured it out....sorry

What about not showing the description I have for the record, the <td>Record</td> part.

Could I use the same sequence but with else statement and how would I write it

<td>Record</td>
<td><% If (rsRecordSet.Fields.Item("record".Value) <> "n/a" Then %>
<%=(rsRecordSet.Fields.Item("record".Value)%>
<% End If%></td>

This works apart from the fact it displays "RecordTrue" instead of just "Record"

Anyone know how to make it just show "Record"


<td><% If (rsRecordSet.Fields.Item("handle".Value) <> "n/a" Then %><%=(rsRecordSet.Fields.Item("Record".Value)<> Response.write("Record"%>
<% End If%></td>
<td class="stadard"><% If (rsRecordSet.Fields.Item("Record".Value) <> "n/a" Then %>
<%=(rsRecordSet.Fields.Item("Record".Value)%>
<% End If%>

Many thanks
ck