I have a table with the following fields: Birder_ID, CountType, CountCounty, Quantity (plus some other fields unrelated to this question).
I have a form that lists 67 counties and the Quantity that goes with each. In other words, the Quantity that would go in the Adams county field would be the Quantity from the table that has Birder_ID = ? AND CountType = 'Life' AND CountCounty = 'ADAMS' (where ? is a session variable birder_ID).
I could create 67 recordsets to retrieve this data, but is there a simpler way to do it?