Recent content by Bouldergirl

Thanks stopher, I just saw your post.... I ended up finding a very similar solution on a different forum site: SELECT Table_1.GRID, Table_1.name, (SELECT TOP 1 Table_2.doy FROM Table_2 WHERE (((Table_2.GRID)=Table_1.GRID) AND ((Table_2.cum_GDD)>=Table_1.min_GDD)) ORDER BY Table_2.GRID...

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 2 1 2.8 2...

Dear DJkarl, Thanks for the advice... I posted this thread on another forum, and someone suggested I use the "RunningSum" property, which, based on the always confusing MS Access documentation, I had ignored as I thought this could only be used for reports. For anyone out there with a similar...

Thanks DJkarl, I will use that query-based approach if need be... I was actually hoping to embed the running total calculation in the VBA module that I wrote which generates my input table in the first place. But thanks for the link! :)

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

Thanks, George, that worked! -Tiffany

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

So the solution, which I got from posting in another forum on another site, did in fact turn out to be a simple crosstab query, the SQL of which follows: TRANSFORM First(Bg.data) AS FirstOfdata SELECT Bg.lat, Bg.lon FROM Bg GROUP BY Bg.lat, Bg.lon PIVOT Bg.month :) In case anyone else finds...

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