In part 2, I would like to see a query where you enter a bunch of parentIDs (such as a field of multiple barcode scans comma delimited) and it spits out a report of all the assets that are included in them. I can't quite figure out how to parse it into an OR statement that works.
Reply from Alex Hedley:
You could do this in VBA. You have the Field name, use Split Split ( expression [,delimiter] [,limit] [,compare] ) Then you could build a dynamic IN ('x', 'y') statement looping your above array Add this to your SQL statement and set that as the Record Source of your Form, that's covered in the SQL Seminars.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
