Search results

This returns the first set of data as per the example. SELECT PUBLIC_RTU_RETAIL_UNIT.RETAIL_UNIQUE_ID, IIf([Settlement_date]=[forecast_date],"WD",DateDiff("d",[settlement_date],[forecast_date])) AS LmDay, PUBLIC_FSH_SETTLEMENT_HISTORY.SETTLEMENT_DATE AS SettDate...

Thanks for the reply Brian. The query still only returns the max date for the range of settlement days. This is only a problem when I have two forecasts for a given day i.e. 02/07/08 31/07/08 + Timestamp 02/07/08 01/08/08 + Timestamp 02/07/08 01/08/08 + Timestamp 02/07/08 02/07/08 +...

That's what it returns. I removed the max as it only returns one date.

Sample data

Haha, touche. That is ofc what I meant. SELECT PUBLIC_RTU_RETAIL_UNIT.RETAIL_UNIQUE_ID, IIf([Settlement_date]=[forecast_date],"WD",DateDiff("d",[settlement_date],[forecast_date])) AS LmDay, PUBLIC_FSH_SETTLEMENT_HISTORY.SETTLEMENT_DATE AS SettDate, Format([FORECAST_DATE],"dd/mm/yyyy") AS...

Hi guys, Potentially an easy one! I have a select query as follows: SettDate ForcastDate 02/07/08 31/07/08 + Timestamp 02/07/08 01/08/08 + Timestamp 02/07/08 01/08/08 + Timestamp 02/07/08 02/07/08 + Timestamp As we can see from the sample, there are two records for the 1st August. I...

try removing the "set" in the line where you set the recordset to tbl1

lol damn you nam!

Just select the name and group by it?

Which company is the check for? I only ask as I work at British Energy :)

Opps missed FldNumber off! Working now :) Sorry to bother you David.

wtf please see attached :)

Hi DC, I've hit an error with the sorting: This data set...

Hi DC, Just got the query working. Going to write the SUMIF part now. Thanks very much :) Much appreciated! I will def use this a lot in the future as transposing data is a very v ery common problem industry-wide.

Hi DC, I thought that was coming. I agree that for most industries this is not in fact normalised data. However, this is standard for the electricity industry in the UK - each period represents a half-hourly value. 3 of the major companies I've worked for operate this way, and National...

Hi guys, Hope you're all well. I have a set of data that has 48 periods per record with +ive and -ive values. I'd like to sum per settlement date across the range where each value is evaluated and summed if it is >0 in one column and <0 in t'other. The processed set of data would look...

Well do you have one at present?

You'll have a value in the first one from selecting an option. Then select a second value in the second combo. I mena you seem to have something that'd work here: If Me.[v]SelectProg[/b].Column(8) <> Me.SelectAW.Column(0) if they're both combo boxes and you've selected the correct columns to...

rovo, remember the first column starts with a 0 too!

The AfterUpdate event of the second combo box