Hello,

I’m trying to set up a delete query.

I currently have a table with 3 columns:

CustNb OrdrNb 1stElecPurch

The CustNb houses the customer number “May be a repeated number” depending on if the customer has more then one order.

The OrdrNb column houses the Order Number. The Order Number is a unique value.

The 1stElecPurch column houses blanks and “X”’s

What I would like to be able to do is:
Find the X and delete every including the row with the X and above until the it reaches the next CustNb

Any help with this would be great and very much appreciated

Thank you

Corey

Can you provide sample data as it would appear before the query was run, and then what it should look like after?

Also, why "X" and not Yes/No?

mmcdonal

DELETE [table.*]
FROM table
WHERE criteria

The DELETE statement has these parts:

Part Description
table The optional name of the table from which records are deleted.
table The name of the table from which records are deleted.
criteria An expression that determines which records to delete.


Remarks
DELETE is especially useful when you want to delete many records.



Thanks,

Rich