Search results
-
R
For Each Change in Value
Thanks for the heads up...I had no idea. rg- rgrogan
- Post #5
- Forum: Modules & VBA
-
R
For Each Change in Value
Someone from another forum gave me the code I was looking for (Below). Thanks for your help! dim rs as dao.recordset dim strSQL as string dim holdA, holdB, HoldX strSQL = "SELECT A, X, B FROM YourTable ORDER BY A, B" set rs = CurrentDB.OpenRecordset( strSQL, dbOpenDynaset) holdA = "" holdB =...- rgrogan
- Post #3
- Forum: Modules & VBA
-
R
For Each Change in Value
Hello...I'm new to this forum...I hope you can help me. I need to come up with a way to derive field X (see below) in a query. For each change in field A, Set X=1 For each change in field B, X=X+1 The below table shows what the query results should look like for field X. Thanks for...- rgrogan
- Thread
- Replies: 4
- Forum: Modules & VBA