update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write an update query that updates a Date field with data the user
enters on the fly. Is this possible? For example, I have a field called
Contract Cycle that needs to be entered on the fly as a criteria for the
update query. I know how to prompt the user to enter this.

In addition, I would like to allow the user to enter the date that the
Contract Sent Date is to be updated to. Can the date that I want be entered
on the fly as well? If so, how do I do this?

Thanks
 
Yes, but I would be very careful about doing this using the method you've
mentioned. I would think you would be better off using a form to get the
information and then referring to the form's controls. The advantage of the
form is that you can verify the user's input before running the query.

SQL parameter statement:
UPDATE [YourTablename]
SET [Contract Sent Date] = CDate([Input Contract Sent date])
WHERE [Contract Cycle] = [What cycle?]
 
Back
Top