Help Me show separate messages against each row of a recordset

[mumtaz]

I have an access database containing one Table having Field1, Field2, Field3, Field4 and Field5.
I want to generate an HTML table in my ASP page and show the records of all the five fields along with one additional field (Let's call it "Field_Message" ). Now, what I want to do is:-

SHOW (Field1) (Field2) (Field3) (Field4) (Field5) along with different types of messages (Message1, Message2...) in (Field_Message) agasint each row based upon some if conditions. For example,

IF (Field1)="" AND (Field2)="" AND (Field3)="No" AND (Field4)=Curren tDate THEN (Field_Message) ="Message1"
ELSE IF (Field1)="" AND (Field2)="" AND (Field3)="No" AND (Field4)<Curren tDate THEN (Field_Message) ="Message2"
ELSE IF (Field1)="" AND (Field2)="" AND (Field3)="No" AND (Field4)>Curren tDate THEN (Field_Message) ="Message3"

Please note that Field_Message Values (Message1, Message2, Message3) may change in each row based upon the above IF conditions.

How to accomplish it?

I am a newbie and would sincerely appreciate even a little hint.