Code:
SELECT Transactions.ID, Transactions.AgencyNumber, Transactions.AgencyName, Transactions.CardholderLastName, Transactions.CardholderFirstInitial, Transactions.Description, Transactions.Amount, Transactions.Vendor, Transactions.TransactionDate, Transactions.PostedDate, Transactions.MCC
FROM Transactions
WHERE ((((Transactions.MCC) Like "*HOTEL*" Or (Transactions.MCC) Like "*MOTEL*" Or (Transactions.MCC) Like "*RESORT*" Or (Transactions.MCC) Like "*INN*") And ((Transactions.MCC) Like "*Restaurant*" Or (Transactions.MCC) Like "*Food*")));