Search results

  1. K

    Update Query

    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]...
  2. K

    Batching Records in Access 2013

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