Search results for query: *

Naw, we're good; I added "INTO Results_Table" after the "...As doy" bit to change to a make table query. Thanks again, AceMan1!

Thanks so much, AceMan1! Sometimes I get so wrapped up in vba that I forget to think in terms of queries. :) It works perfectly!

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

Dear Gruuuu, you are a Guru! Thanks so much. With just a few minor tweaks, I made your suggestion work perfectly! For those out there who may be looking to do a similar thing, here's the final code that works for me: Option Compare Database Option Explicit Function Calc_cum_GDD() Dim db As...

Hi Gruuuu, thanks for your reply.... Conceptually, I know what you are talking about, but pragmatically, I don't know how to save the value and compare it to the next one.... I do think that rinwd.zone is a collection, since collections are objects of the same type (and I guess my column called...

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

Dear MichaelRed, 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...

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

Whoops! I didn't include the entire code, so here it is: Function CalculateHeatUnits() Dim db As Database Dim tdfNew As TableDef Dim rin, rout, T_mean, T_range, theta, Pmon, GDD, Asin2 ofilename = "growing_degree_day_test2" Set db = CurrentDb() For i = 0 To db.TableDefs.Count - 1...

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

Yes, that was exactly what I needed; thanks!!!!

I did look into a crosstab query, but I don't want to have row headings or perform any sort of arithmetical operation, and the crosstab query wizard wouldn't let me do it the way I wanted to. :(

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