Does anyone know a formula for an items on a transaction search, I need to get items 50 to 100 but on the list it's 1 to 200.

Do you mean the ID of the item? Or the line itself.

Item number, controller gave me range of numbers he wants to look at.

There are few items before and few items after which he doesn’t want to see, so I started with any of , then I thought maybe none of would work but for both it’s too many items to include and I cannot multi select on that item pop up

you might have to do some sort of fancy regex

Regex?

Regular Expressions.

Hmm you mean sql ?

If you've never used regex before this will be challenging

Hmm thanks I might need to go to partner for that, I also thought of just exporting it and chopping in excel

Ok, now I understand your question better... Why not just add a custom checkbox to your items, do a csv import or mass inline edit too set it to true and then use that field as a criteria instead?

☝️

that might be a possibility good idea!!