Search results
-
S
Access SQL query with conditions?
I am trying to update a table using values from a mapping table. I think its an UPDATE and SELECT statement but I cant figure out how to handle conditions. This is in VBA Access. I have two tables with following fields: mainTable: [column1],[column2],[mapColumnA],[mapColumnB] mapTable... -
S
Improve query performance - copy and sum
Hello, I was searching for some help trying to improve the performance of VBA function in access. I have two functions that are taking 40+ minutes to complete against a table that has 300,000+ records. I'm running on a quad i5 processor laptop. I'm not sure if my query can be improved, or if...