[HELP] Covert Col to Row & Del Row where x is empty

[harky]

After key in the Code, it become like this

BS_Code	ContractID	Install BS Per Day	LayoutID	Qty
1111	2019	100	228WP	1
1111	2019	100	705WP

I want to delete the row if [qty] col is empty.


Result should be this

BS_Code	ContractID	Install BS Per Day	LayoutID	Qty
1111	2019	100	228WP	1

SELECT TbInvoice2.BS_Code, TbInvoice2.ContractID, TbInvoice2.[Install BS Per Day], '228WP' AS LayoutID, [228WP] AS Qty
FROM TbInvoice2 where null is null;
union all
SELECT TbInvoice2.BS_Code, TbInvoice2.ContractID, TbInvoice2.[Install BS Per Day], '705WP' AS LayoutID, [705WP] AS Qty
FROM TbInvoice2 where [705WP] is null;

 

[welshgasman]

sorry i dont know SQL so tht was testing..

the fact is base on QTY.
If qty is empty, the whole row del, tht what u see on the result

SELECT TbInvoice2.BS_Code, TbInvoice2.ContractID, TbInvoice2.[Install BS Per Day], '705WP' AS LayoutID, [705WP] AS Qty
FROM TbInvoice2 where [QTY] is null;

None the wiser

If you just want to delete rows where qty is Null, just use that as criteris in a Delete query.?

Delete query syntax

 

[harky]

sad..........

None the wiser

If you just want to delete rows where qty is Null, just use that as criteris in a Delete query.?

Delete query syntax