Delete Query Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a delete query that deletes all record marked for but the record that
is on record pointer.
 
Do you have a question?

Please state your question. Make sure to include details. What does your
query look like?

Rick B
 
The details are: Query: qryEmployees, Fields: LastName, FirstName, PrintLabel
PrintLabel is a Y/N text.

I am sorry is not a delete query. It is a clear query for a true condition.
UPDATE qryEmployees SET qryEmployees.PrintLabel = False;
This query clears all record marked true to false.

I have a form is tabluar format: with the three fields displayed. When the
Printlabel box is checked the label is marked for printing.

I have a query that clears all record marked for printing. It clears all
check marks, but the record that has the record pointed does not clear.

I hope this is clear.
Thank you
 
Back
Top