Hi all;<BR><BR>I am trying to generate and SQL statement to get transactions for a given user. I want to get only transactions for one user and if they are a type that start with Payment or are Void.<BR><BR>The SQL statement I have below does not work. It gets the right transactions for the right user. However, it gets the transaction types Void for all users. Make sense?<BR><BR>rsTransaction.Open "SELECT * FROM Transactions WHERE UserName = '" & strUserName & "' AND Type LIKE 'Payment%' OR Type = 'Void'", objCustomerConn, adOpenDynamic<BR><BR>How do I change this SQL statement so that I don't get data on Voided transactions for users that didn't have transactions voided?