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