Skip to Content
0
Sep 21, 2016 at 03:04 PM

How to use a AND/OR statement in Query

22 Views

All,

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

WHERE

T0.[CardCode] ='[%2]'

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.

Keith H