Recent content by kelesb22

Any assistance would be appreciated. I'm still racking my brain on this. I would like to update Top 50 records with the smallest check number as the batch number within the Top 50 record set. The smallest check number will be the batch number for the Top 50 records. My error message is...

I'm looking to pull the smallest check number to use as a batch number, not do a sum. I also tried using a different method. My error message is "Operation must use an updateable query" This is the query I used when using the temp table. UPDATE [Table2] SET Batch = (select...

Hello. I'm trying to do an update query in Access 2013 with SQL. I need the Set value to equal the min check number from my sub query from the update statement . UPDATE [Table1] SET Batch = min[Check Number] WHERE ((([Table1].[Check Number]) In (Select Top 50 [Check Number] from [Table1]...

Thank you both. I have my Add and Update queries all set. Could you explain how I would have this run till Dcount is 0? Is there a setting in the Macro that will repeat this process until Dcount is 0?

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...