delete query

[Jen0dorf]

Hi

I have two tables with some non matching data. Graves and Memorials

I have created a query to separate the non matching fields as below,

FROM Graves LEFT JOIN Memorials ON Graves.[MLink] = Memorials.[MLink]
WHERE (((Graves.MLink) Is Not Null) AND ((Memorials.MLink) Is Null));

I now want to use this query to change the field Mlnik from a text value to Null

I realise that I am unable to delete the record from the query so is this possible?

I did think of creating another field in Graves, inputting a standard value using the filter query as criteria to only mark the records I want and then create an update to change all fields with that value to Null



This seems a bit clumsy is there a better way?

Thanks

Ian

[NTC]

While I don't follow the specifics of what you are doing - one can use an Update query to change values - and that includes updating to "" which will be equivalent to null.