Can someone please help me with the following:
I have a form that has up to five fields that can have entries in them.  I 
want to be able to UPDATE the relative fields  in a table based upon 
whether or not there is an entry in that particular form field.  What I 
don't know how to do is phrase my UPDATE statement accordingly.

How do you say in SQL (if something is in any of these form fields then SET 
the appropriate table field to what's in the form field WHERE the IDNumber 
(from the table) =  Session("IDNumber")?  Someone told me to do a dynamic 
query (which I don't know how to).  How do I do the above and is a dynamic 
query the right approach?

How will the action page know which of the five have entries in them?