I'm connected to and manipulating a Access Database using a VB frontend. But I'd like to add a simple table with 2 fields and populate it and I'm not sure how to go about doing this, google ...

Case clauses in Visual Basic are cool. You can load them up with all kinds of expressions and method calls, allowing you to fine-tune your criteria: Select Case patrons Case 1, 2 ' ----- Small table: ...