AccessUser123
Last Activity: May 20 '11, 01:23 PM
Joined: Apr 20 '10
Location:
-
I have not run this code on very large sets of data, but shows instant results on the 100-200 rows of data that I have tested it on. Hope this helps. -
I just found the VB Code to do it and it works great!
Code by Harlan Grove
...Code:Sub findsums() 'This *REQUIRES* VBAProject references to 'Microsoft Scripting Runtime 'Microsoft VBScript Regular Expressions 1.0 or higher Const TOL As Double = 0.000001 'modify as needed Dim c As Variant Dim j As Long, k As Long, n As Long, p As Boolean Dim s As String, t As Double, u As Double
Last edited by Niheel; Mar 11 '11, 07:12 PM.Leave a comment:
-
Excel Formula Question
Is there a function in Excel that will find which cells within a range that sum up to a predetermined value? i.e. I have a range of 1,000 cells with number values and I want to know which cells sum up to 467. -
Sql
...Code:SELECT [Labor List].Clock, [Labor List].Name, [Labor List].Department, [Labor List].[GL Account #], [Labor List].[Period Hours], [Labor List].[Period Gross], [Labor List].[PAY PERIOD], [Labor List].PSID, [Labor List].[Pay Rate] FROM [Labor List] GROUP BY [Labor List].Clock,Leave a comment:
-
Allow Duplicate Entries in Access
I am trying to get my Access database to INCLUDE duplicate records. I have a simple database with one table that does not have a primary key and I am using one query to generate a report. The data has a lot of duplicate records that need to be included in my report. Is there a way to include duplicate records so that they will show on my report. All table fields that are indexed are set to "Yes, Duplicates OK" and all fields in the...
No activity results to display
Leave a comment: