How to pass arguments from an Access form to SQL Query with "IN" clause? -
i'm having trouble getting query display results. select evaluation_table.* evaluation_table (evaluation_table.test_id in ([forms]![test data]![group_test_ids])); the control, [group_test_ids] textbox contains string of ids. example contains numbers separated commas: 1,2,3,4,5. while debugging, if changed query this, returns records: select evaluation_table.* evaluation_table (evaluation_table.test_id in (1,2,3,4,5)); i can't seem find proper syntax. sql in access can weird. i can't seem find proper syntax. that's because there none. the in selection cannot dynamic; option rewrite sql via vba.