Hi,

I am currently working on a Database which holds names and addresses of customers. The addresses are split out over 6 fields (address 1, address 2 etc)...

Some of the addresses get populated with a fax number in field address 5 or field address 6 which I want to have removed.

Does anyone know how to do this? I don't want to delete the entire record, just the actual word "fax" and the fax number which follows from each individual field.

Thanks

You need to fun an update query on the field and set the field to null where the field like "fax*"

Thanks buddy! I didn't even think of that...i was thinking about a delete query! Madness from me.

Thanks again!