Search results for query: *

I'm sure I'm missing something obvious, but here's my question. Consider the table below. tblData x y z --------------- 12 1 821 12 2 230 12 3 614 12 4 560 56 1 829 56 2 200 56 3 604 56 4 588 42 1 816 42...

I have a table, below, where each record has 3 distinct values between 1 and 9. ID v1 v2 v3 --------------------- 1 1 6 2 2 4 8 1 3 3 5 4 4 3 8 5 5 8 7 9 6 etc... I want to identify all sets of three IDs that...

hello to all I'm VERY new at VBS. The following code gets the names of all the .mdb files in a specified folder, then writes these names to a file called TEST3.txt. It works perfectly. What I want to do instead is write the mdb file names to an ACCESS table. (in TEST4.mdb, table...

Consider table tblA to the left. Each ID has rows 1 to 6. For each ID, the 6 values of valx and valy form 3 matching pairs, each written both 'forwards' and 'backwards'. For ID = 91, the three matching pairs are (24, 19), (18, 20), (21, 16). I want to get output like the table tblB...

hi to all. I'm quite new to VBS, but I could use some help. I have a table in an Access mdb like this... X Type -------- 11 234 14 7 22 98 23 118 36 47 etc... I want to step through each X value then do an analysis based on the Type value. In VBA, I would just set up a...

I have a table like this... Field ID is autonumber and pk. Field X is Long. ID X -------------------------- 1 1,271,234,567 2 2,035,222,123 3 1,997,276,330 4 5 2,009.776,197 ...etc The values of X are very large and, on...

hi to all I have a table as shown below. Every ID has ranks 1 to 4. ID rank X Y ------------------------- 24 1 4 24 2 0 24 3 3 24 4 6 25 1 0 25 2 0 25 3 8 25 4 2 26 1 etc... Within each ID value, I want...

hi to all I have a table like this... The PK is Type & Rank. SubType is either 1 or 2 (ASC). x holds single-character string values. Type Rank SubType x ================================= 100 1 1 2 100 2 1 4 100 3 2...

hi I have a table that has 8 records... tbl_1 X Rnk 2 1 2 2 3 1 3 2 4 1 4 2 5 1 5 2 I need to find ALL ways to permute these 8 records in a column subject to the following contraints... (2,1) precedes (2,2), (3,1) precedes (3,2), (4,1) precedes (4,2)...

My table has 3 fields, A, B, and C. A & B form a compound PK, and C is initially empty. There are exactly 4 values of B for each A. These 4 distinct values of B in each group are listed in increasing order, and are taken from the set 1, 2, 3, 4, 5, 6, 7, 8. My task is to fill column C with...

hi to all I have a table as shown below. ID1 is an autonumber field. ID2 increases by 1 after each 6 records. For each ID1,ID2 combination, there are 7 values of Val listed in increasing order. The 7 values of Val are taken from the integers 1 to 12 with no repeats. ID1 ID2 Val...

hi I have a table as shown below. The actual table would have about 150 records and about 10 different teams. AthleteID Team Score ----------------------------- 123 Bears 3.00 124 Tigers 4.90 131 Bears 5.75 132 Bears 7.20...

hi to all I have a table (tblTargetCells) with 2 long fields, col and row. There are typically about 100 records. col row ======== 1 3 1 12 1 25 2 4 2 35 3 17 ... etc 22 18 22 50 There is a 2nd table (tblOutput) that has long values in, say, 23...

In my code, I create and fill a table that typically has about 100,000 records. The first field, ID, is an autonumber field. Later in my code, I copy this table to other MDB programs. Doing this causes the ID numbers to keep incrementing, but I want each copy to be IDENTICAL. So, I try to...

hello I am asking for help writing a query (or, possibly, VBA). Consider two tables, tblA and tblB. tblA [PK: X, Y, c] tblB [PK: X, c, r] X Y c MatchCount X c r...

hello - I'm completely new to VBScript, but I'm hoping for an answer to what I think is an easy question... My VBScript opens MS Access and runs several VBA functions (DAO). At this point, I need to pass a single long value back to VBS. How do I do this? Thanks in advance.

hi to all Is is possible to programmatically add comments in the top line of the Description column in a table's Design View? Thanks in advance teach314

hello - I need assistance with a query (or possible VBA). Here's the situation... I have a table like this: (each X value appears at least twice) X Y ========== 1000 1 1000 31 1004 4 1004 18 1023 8 1023 79 1023 83 1101...

hello to all I think this should be easy, but I'm missing something. I have a function that has an Argument (nColumns AS Long). In the function are two lines that depend on the value of nColumns. Let's say nColumns = 5. So, I'd like the two lines to look like this... FldStr =...

hello to all I have been using an MS Access 2002 athletic meet scoring program that I wrote some years ago. Now, when I click a cmd button to open one of my Reports, I get the following message... "Error No: 2465; Description: B_Meet_Scoring can't find the field 'Forms' referred to in your...