Recent content by pachederm

0 down vote favorite Hi, was wondering if anyone can help me out with this. I have a table and a query both of which have the same [Resource ID], [Resource Name] fields. I am trying to update the [CBL_1_Date], and the...

Hi Plog, I'm not sure how I can make it any clearer. The excel spreadsheet in my previous posts has a tab labeled "result table" - I have attached it again. I am just looking for a subset of the original data source query, which again is the first 4 rows of each group. The resultant data...

Hi Plog, Yes, Data is grouped by [Resource ID] and [Event Start Date] Afterwards the data in each group is ordered by [Curtailed kW] in descending order. Getting a subset of the starting data via SQL is the most complicated part. In the end, I will need a data set that is the average of the 4...

Hi, The data is ordered by "Resource Name" (ascending), "Event Start Date" (ascending) and "Curtailed kW" (descending). The max value for "Curtailed kW" is always at the top of each group. If there are more than 4 rows (i.e. 6), then I can only take the best 4 out of six (i.e. the top 4)...

sorry attached please find the actual excel spreadsheet with the data source and resultant table. the last post looked a lot nicer on my screen before I hit the submit button.

Hi Plog, Thanks again for your response and assistance. Below are two sets of data....the data source (qBulkProcess) and the resultant data set (qLimit4). I did add the field "index" which is an autonumber in hopes that it would help. DATASOURCE (qBulkProcess) index...

Thanks again. I'm not sure if you downloaded the files in the last post which had some screen shots from the DB illustrating the issue. I attached another file after exporting the query to Excel and manually tried to show what the resultant query would look like. The data source is a query...

Thanks for responding. I attached a screenshot of the query so that it can be explained pictorially as the file is very big. Below in RED is the data we want which we will later average into a single number for ID/Name. We are basically taking the Top 4 records of each group.I have a lot of...

Hi, I've been rattling my brain over this all day and was wondering if someone can help me out. I have a query with about 7500 records that are grouped as follows and sorted by Mtr_Reading ID Name Event_Start_Time _Hour, Mtr_Reading 2210 XYZ 7/15/2013...

Yes the Bob, worked fine.......took 3 days to figure it out but hey, i'm all the better now

Didn't work. When I look at the watch window, the code looks like this rsCBL!["CBL_1_Date"] with quotes, and I get an "item not found in collection" error. If I hard-code .ReadDate = rsCBL![CBL_1_Date] for example, it works fine.... I looks like there are "quotes" in the calculation of the...

Thanks Mark, I'll try it tomorrow when I get into the office... you know...come to think of it, the resultant string in the watch window did look like it had spaces in it...I though it was just screen formatting. thanks again!

Help! I have a query with enumerated field names (i.e. CBL_1_kW,CBL_2_kW,CBL_3_kW,......CBL_10_kW) I'm trying to construct the field names with a counter and feed them into an array where I can sort them later. (i.e. rs!["CBL_"& Str(i) & "_kW") The problem I am having is that the program...