p2p.wrox.com Forums - View Single Post

pgtips · #2 (**permalink**) July 24th, 2003, 08:06 AM

Try this instead of your multiple If/ElseIf statements:

Code:

strWebLogActivityTable = strWebLogActivityTable & "<td align='left' bgcolor='#FFFF00' width='100'><b>" & trim(rs("access_date")) & "</b><br>"

strWebLogActivityTable = strWebLogActivityTable & _
    WeekDayName(Weekday(rs("access_date"))) & _
    "</td>"