I have a basic query that now has a twist:
SELECT T0.[CardCode] AS 'Vendor #',
T0.[CardName] AS 'Vendor Name',
T0.[DocNum] AS 'P.O. Number',
T0.[DocDate] AS 'Posting Date',
T0.[DocDueDate] AS 'Delivery Date'
FROM OPOR T0
and T0.[DocDate] >='[%0]'
and T0.[DocDate] <='[%1]'
I need to someohow present this query as a Select Vendor AND/OR Posting Date
As a side note - can I add columns with no data in them? Basically just add an extra 2 column that says "S/N" and "Text"
As always any help is greatly appreciated.