Delete query for one field only

[dark11984]

I am having trouble making a delete query for a table of mine.
In my table i have products, Qty on hand, qty on order, reorder points.
I want to add in a comment field so that i can make comments about the products that are low on stock. I than want to be able to than run a delete query that deletes the comment field only of the products where the qty on hand is higher than the reorder point.
At the moment my query deletes the whole record, I want to be able to keep the record and only delete the comment field.
Hope this makes sense?

 

[georgedwilkinson]

Don't use a delete query, use an update query. Set the "comment" field to "". In the criteria, put "where QOHFieldName > ReorderPointFieldName"

 

[dark11984]

The only problem I have with that is each day I import the product table from an external spreadsheet so it deletes anything from the previous day in that table.
I was going to import my spreadsheet into the product table and than update it into second table and run the comment update query off the second table, but the problem I will have is if new products get added to the external spreadsheet that is imported than they won't be updated to the second table.

Any ideas how i can get around that?

 

[georgedwilkinson]

No, I can't help.

Seems you are using Greek and I only understand Latin.

NE1 else wanna try?

 

[Swillsy]

Hi Dark,

I'm not too sure however to me it sounds like you are using an access table and an excel sheet at the same time and you want them updating. So if something is added to the excel sheet it gets aded to access and vica versa?

 

[neileg]

You seem to have ignored the answer from George and asked a different question. You're going to have to explain what you want in more detail.