Search results for query: *

hi prex1 Thanks for those two good ideas. I'm guessing it should also be possible to use the numpy.where, but I haven't been successful yet (ie: iterating through the array values to determine the indices of each value. That could be the fastest of all.

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

Thanks for responding, Andy. You're right - the point is... on which record in this table? That brings it into clearer focus. For each table that matches "tbl_*", I want to count the records where Field sType = "K". . How could I set that up? Thanks, Vicky

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

hey Duane - Works perfectly! Thanks, Vicky

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

thanks, Skip, for a quick response, and for the advice. Vicky

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

VickyC - I'll retract the question! The answer is obvious.

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

skip - nice answer!

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

hi Skip - you're format suggestion worked. What puzzled me was that my code worked in the past. I moved all tables, queries... into a fresh mdb file, and now my original code works once again. Thanks for taking the time Vicky

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

hi MajP - Thanks for the great reference. In the meantime, I had worked out a solution using recordsets in VBA, but I should now be able to develop an SQL solution. Vicky

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

hi PHV - I just tweaked your first attempt a bit to give the following... UPDATE tblTEST A INNER JOIN tblTEST B ON (A.Row = B.Row) AND (A.Val1 = B.Val2) SET A.Val2 = -1*(B.Val1) WHERE A.Val2 = 0; This works perfectly. Thanks for the major hint, and for your 2nd solution as well! Vicky C.

hi PHV - thanks for responding. Your suggestion looks really close. but I have a few comments... 1. I think the last part of the subquery's WHERE atatement should be B.Val2 = A.Val1, not B.Val1 = A.Val2 That would make the code like this... UPDATE tblTEST2 A SET A.Val2 = -(...