Search results for query: *

I have 2 tables, Table 1 and Table 2 (see attached images)….Although in the example tables (attached), only a few records are shown, they both have about 1000 GRID values: Table 1 contains anywhere from 1-20 records (i.e., rows) per GRID value containing unique “spc_ID” and “name” values, while...

Hello, I have an input table like the following: ZONE DOY GDD 1 1 2.3 1 2 4 1 3 7 1 4 3.1 2 1 2.8 2 2 6 2 3 4.7 2...

Hello, My problem is this: I have an input table (called rin in the following code) with a field (GDD) that I am hoping to create a running, cumulative sum of (in the output table field called “cum_GDD”) and pass these values into an output table (rout). I realize that VBA doesn’t have any...

Hi there, I've got a function and within it are embedded 2 other functions (CalcAsin2 and CalcGDD), which are called from within the main function. The code seems to run (i.e., no error messages, and the output table that I create is made and populated with most of the values I want) but the...

Hello, I've got a bunch of cells which contain long, variable-length strings of data, and nested inside the string is a set of parentheses. e.g.: this+isAll&unnecessary" stuff">Idon'tneed>(but this part I need)<followed by&MORE unnecessarySTUFF So I ONLY want to count the number of...

Hello, I've got a rather large table (~650,000 rows) with 4 columns: latitude, longitude, month, and a column of data (where each value is a function of latitude, longitude, & month): lat lon month data 40 120 1 10.23 40 120 2 51.8 40 120 3 0.001 60...

Hello World, As I can barely write code that prints 'Hello World', I am in need of some assistance: So I've got a module that basically imports every excel table in a particular folder into a db. Each table is named according to its excel filename. Each table also has 2 fields: 'VALUE' &...