hi folks, hoping someone can help me out with this one:
I have a report.asp page where i display data from an Access query. I know how to set my table so that each row will alternate 2 colors back and forth, but can i set the background color, based on a value in a field.

When someone enters data in my form, one of the fields is called "recency" Here they must select whether the data is "new", "ongoing", or "expired". These are text fields in my db.

Soooo, when i show all my records in my report, I want to be able to base the bgcolor for a particular recordset, based on the value that record has in it's "recency" field. i.e if that recordset has "new" in the Recency field, then display the row background in green, if it is "ongoing", then the row background should be yellow, etc etc

Any ideas?
Here is a couple lines of my code where i display the data:

  <tr VALIGN="TOP">
    <td><%Response.Write RS("planno")%></td>
    <td><%Response.Write RS("type")%></td>
    <td><%Response.Write RS("company")%></td>
  </tr>

Right before displaying the table row I would put a case statement in. Something like this:

<%
dim strBGColor
select case rs("recency")
   case "new"
      strBGColor = "green"
   case "ongoing"
      strBGColor = "yellow"
   case "expired"
      strBGColor = "red"
   case else
      'Logic for alternating row colors here
      if altrow then
         strBGColor = "white"
      else
         strBGColor = "lightgrey"
      end if
end select
%>
  <tr>
    <td bgcolor="<%=strBGColor%>><%= RS("planno")%></td>
    <td bgcolor="<%=strBGColor%>><%= RS("type")%></td>
    <td bgcolor="<%=strBGColor%>><%= RS("company")%></td>
  </tr>

That should give you a start.

You could also create a 2 dimensional array to store the status/color combo and loop through the array comparing the status with the records status and assign strBGColor a color value that way. That would eliminate the case statement which cuts down on the number of lines of code. It would also make updating it easier.

Or you could just use COLOR="******" for each one! (If you have a set amount of cells...)

right you could use bgcolor="" for each <TD> though the ASP Solution is nicer and better