I am working on a database I created and imported data from Microsoft Excel. Now I want to use a series of values in one column in the IN operator with parenthesis as multiple criteria. I understand typing one criterion and inserting a comma is an option but considering the number of criteria, I will like to know how to add the commas to vertically arranged criteria.

SELECT [user], [real date], [accounting date], [Account Name], wording, Column1, amount, [Transaction Reference], Operation, balance

FROM dbo.TJ111

WHERE [account number] = 571000900025700

OR [Transaction Reference] IN (

000000188646,
000000188650,
000000188854,
000000189012,
525555555555,
kkkkkkkkkkkk,
etc)