How can a userNum = an ID Number which is filtered on the name Tina?
WHERE (description="old description"
Does your field description contain an entry called old description?
How can description be set to Hello and equal old description in the same query?
To be of most benefit to you try writing out in Word or Notepad what you would like the result of your query to look like, then zip it and your database and post to this forum. Somone will solve it and return it, then you can look at it and make small changes to the queries to at least get a better idea as to what is happening.
What I'm trying to do is an UPDATE query which will update schedule.usernum and schedule.description. In order to update schedule.usernum, I would like to be able to submit a name from users.name and have the database look up the corresponding ID to UPDATE the schedule.usernum to.