Search results for query: *

Consider a numpy array like this... a = array([1, 7, 2, 8, 1, 2, 3, 8, 5]) Some of the array elements appear just once (ie 3, 5, and 7), but we are interested in the array elements that appear twice (ie 1, 2, and 8). I need to find the GAP (index difference) between identical elements. In...

hello all Consider the code fragment below. I loop through a set of tables in an mdb file. If the table matches "tbl_*", then I call a function. This works PERFECTLY. Dim db As DAO.Database, tdf As DAO.TableDef ... Set db = Workspaces(0).OpenDatabase(strExternalPathName) For Each tdf...

hi I have a huge table like the one at LEFT. For each ID, Rank runs from 0 to 4. The ID increments by 1 after each set of 5 records. I want to insert a new record at the beginning of each group of 5 records. This is shown at RIGHT. For each of these new records, the last 3 fields are -1...

hi - I'm totally new to Excel VBA. I've need code to copy the tables in a set of worksheets into Sheets(1). All works perfectly. But, I now want to fill the header row cells of each table using, say, colorindex = 37. As I loop through Sheets(2) to the end, I run the following code...

hi I want to use 2 Long args and 1 ParamArray in my function below... Function TEST(X As Long, Y As Long, ParamArray Arr() As Variant) Debug.Print LBound(Arr), UBound(Arr) Debug.Print Arr(0), Arr(1) End Function When I run TEST(10, 20, 5, 3), the output is... 0 1...

hello to all Here is a sample from a table... (* sorry, but I can't get the TGML to show the tables properly??? I'm using tt and /tt in square brackets) Row DataVal 1 7 2 2 3 8 4 -2 5 -3 6 -4 7 -8 8 4 9 5 10 -6 11 -7 12 3 13 6 14 -5 I need help writing a query to a) Group...

hello I have a question that has me stumped. Consider a large table as shown below... ID A B X1 X2 X3 X4 X5 X6 ==================================================================== 1000 1 6 1 6 6 10 6 1 1001 3 15 15 15 3 3 3 3 1002 13 8 13 8 13 8 8 13 1003 34 16 99...

hi to all. I have thousands of reference tables with names like tRef__nOT_4_sOTX_12_v23. These are stored in multiple MS Access 2002 mdb files. Recently, a problem has arisen, and I think it may have happened when I switched from Windows 7 to Windows 10 (not sure). Here's the problem: The...

Greetings. I am having trouble with the PIVOT statement in a cross-tab query. Given table tblX__NORM below, I want to produce the query output below that. tblX__NORM ASch ARow X 1 1 1 1 2 1 1 3 1 1 4 0 1 5 1 1 6 1 1 7 1 1 8 0 1 9 0 1 10 0 1 11 1 1 12 0 1 13 0 1 14 0 2 1 1 2 2 1 2 3 1 2...

Greetings I am asking for some help with the following problem... Consider table tData ID1 ID2 ID3 X ==================== ... 20 1 1 87 20 2 1 62 20 2 2 91 20 2 3 32 20 3 1 74 20 3 2 17 21 1 1 87 21...

greetings I'm asking for help in writing an UPDATE query. As I'll explain below, the UPDATE rule is a bit peculiar. Consider the following table. Val1 runs from 1 to 8. For each Val1, Row runs from 1 to 14. So, there are 14 x 8 = 112 records. For exactly half (56) of these records, Val2 =...

hi I have a loop in VBA code that needs to retrieve the number of records in a Totals Query on each loop iteration. Between each iteration, changes have been made to the underlying table, so I need to retest the number of records in the Totals Query with each loop. I currently use DAO to...

I have code that works well, but I feel it is inefficient. The following table captures the essence of my question: tbl_Data_Output_150218 ID (Auto) P X Y Z 1 1 32 187 945 2 1 116 33 4 3 1 78 877 129 ... 32 1...

hello to all Consider a table like this: ID Rank Value ===================== 1 1 1 1 2 7 1 3 10 1 4 14 1 5 23 1 6 50 2 1 1 2 2 7 2 3 11 2 4 14 2 5 23 2 6 50 3 1 1 3 2 6 3 3 7 3 4 10 3 5 11 3 6 14 3 7 23 3 8 49 3 9 50 4 1 7 4 2 11 4 3 23 5 1 7 5 2 11 5 3 23 I want to find which IDs are...

hi to all I am looking for a way to make some SQL more efficient. The code I have works well, but I need to apply it 6 times to get the desired result. Here's the situation... Tbl_1 Tbl_2 ===== ===== ID_ABC A...

hi to all Consider a table like this... Term Rank K 1 1 1 1 2 1 1 3 0 1 4 0 1 5 1 1 6 0 1 7 0 1 8 0 1 9 1 1 10 0 2 1 0 2 2 0...

hello to all I am asking for help with a problem I'm having with using SELECT FIRST in a TOTALs query. Here's the situation: a) In VBA, I generate code to INSERT INTO the table shown below in b). So far, so good. TABLE1 ====== b) AutoID ID_X ID_Y Val1 Val2 (nb: Val2 = 1 +...

hi to all I have to keep this question in general terms - to go into detail would just drown the central issue. Imagine VBScript that is used to run code in a CONTROL.mdb file. This CONTROL.mdb code creates a different QueryDef to UPDATE tables in hundreds of EXTERNAL mdb files, each...

Hi to all. I am asking for help with a problem where I use the data in 3 tables to fill a 4th table. This is part of a larger problem, but I tried to represent my difficulty as clearly as I can. Start with two tables, tbl_Pos and tbl_Neg. tbl_Pos tbl_Neg Val_P...

greetings Consider the following table. The PK is (Set, Posit). Each Set has exactly 5 records as shown. Set Posit X 1 1 4 1 2 5 1 3 5 1 4 5 1 5 2 2 1 0 2 2 0 2 3 6 2...