I'm very new at this and was hoping someone might be able to provide a code sample for me to work off of.
I have an Access db that gets a weekly import of 2,000 + records. These records need to be sorted by type then batched in groups of 50. The tables need to be updated with the batch id. Would I want to do a loop in VBA to update the top 50 records? Is there a way to do this in Macros or the SQL statements? I'm not finding any useful code samples online, this could be from my lack of knowledge of VBA. Any assistance would be much appreciated.
:banghead: