Help with a Select statement 1

[Bennie47250]

Using Crystal 7.0 on a MS SQL table

Not getting the desired results from this select statement, I’m getting records that are out of the Invoice_date range and Order_Type.

I’m sure it needs some parentheses but I’m not sure where to put them.

Thanks

{Table2.Invoice_Date} in {?BeginDate} to {?EndDate} and
{Table2.Order_Type} like "N*" and
{Table1.Sales_Region} <> 98 and
({Table2.ItemType} = "P" and {Table2.Product_#} = "M140024")
or ({Table2.ItemType} = "L" and {Table2.Product_#} like "MCHW*")
or ({Table2.ItemType} = "P" and {Table2.Product_#} = "M140044")
or ({Table2.ItemType}= "P" and {Table2.Product_#} = "M140044DS")

 

[IanWaterman]

You need to wrap this bit in ()

(
({Table2.ItemType} = "P" and {Table2.Product_#} = "M140024")
or ({Table2.ItemType} = "L" and {Table2.Product_#} like "MCHW*")
or ({Table2.ItemType} = "P" and {Table2.Product_#} = "M140044")
or ({Table2.ItemType}= "P" and {Table2.Product_#} = "M140044DS")
)

Ian