Delete Query

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

Guest

I created a delete query which should delete ALL records from a tabe. In the
table is no flag field to mark the records which should be delete because I
always want to delete all records from that table.
(For other flaged tables I use the criteria: -1.)
What do I have to write in the criteria if I would like to delete all
records in the table?
Thanks for helping me
Klaus
 
hi,
put no criteria. here is a delete query i use to delete
the entire contents of a table.

DELETE tmpHistGL.* FROM tmpHistGL;
 
Hi and thanks
You know I am more or less new to this and I tried what you wrote but I
think I made a mistake.
Here is my Query:
Field = Offset Orders.*
Table= Offset Orders
Delete = From
Citeria =
What did I do wrong?
Thanks
Klaus
 
Back
Top