Update queries (1 Viewer)

[Jon Mace]

I have written a data base for a recruitment agency that deals with temporary workers, basicly one of the tables is the weekly schedule and has a tabulated form with all the worker details on the left and then the days of the week accross th the right, each day has 2 boxes the 1st is a combo box with the clients details and the second is a notes box. What i want to do is at the end of the week clear each individual day if the notes box does not say "regular" I have tried an update query that states:-

Field - Monday - Mon Notes
Table - Sched - Sched
Update - Null - Null
Criteria - - Not Like "*regular*"

For some reason this does not work any advise would be appreciated.

Regards Jon Mace

 

[Tim K.]

Criteria - - Not Like "*" & "regular" & " *"