Type conversion failure

[cornishteeth]

I have a table labeled tblStudent with 8 fields. I created an update query that when selected deletes all the data (Dates for the week) in one of the fields by putting "" in the update to criteria. Most of the time it works, but some of the time, I get a type conversion failure on all records and an error message that reads "Microsoft Access cannot update all the records in the update query." Am I using the update query when I should be using something else?

Thanks,

Frank

 

[BrianB]

Update query is OK.
Are you mixing Text (="") and dates ? ie. Is it a Date field ?

 

[cornishteeth]

The field I am using the update query to delete is in fact a Date field. It does work, but I get that error message. Is the "" only to be used with text? If not, what should I use to clear dates. The reason I am asking is that I am attempting to clear not one, but two field simultaneously. When I try to clear two fields, it does not work. The first is a DATE field, the second is a TEXT field.

Frank

 

[pritcham]

You can set the fields to "Null" (without the speachmarks) - this will work for all field-types (as long as you haven't set the field so it doesn't accept them).

Martin

 

[cornishteeth]

Thanks. Works like a charm.

Frank