I need to write a query that will set the Field InvoiceinPer value to Y if the order# is the same and the date is the same regardless to the transType. (see example1)Example2 Will set the invoiceinper value to Y only if the transtype is anything other than Credit or rebill and the dates are different.