Search results

Cool, thanks for that.

Fields are DMACode, PropID, Max([All meter reads].ReadDate) - Min([All meter reads].ReadDate) as NumDays, Max([All meter reads].Reading)-Min([All meter reads].Reading) AS TotConsum, TotConsum/NumDays AS DailyHHConsump, DailyHHConsump*365 AS YearlyConsump Ideally I am looking to sort by...

Hi, I have a query which is something like select A, B, C, B-C as CalcField1 From Table Sort by CalcField1 When I run this query it asks for a paramter value for CalcField1 so before I tell my manager to sort it himself manually after running the query is there any simple way to sort on a...

Public Const cRunIntervalSeconds = 10

xlWSh.Range(xlWSh.UsedRange.Find("Isolate AST Results").Offset(2, 0), xlWSh.Range("I" & xlWSh.UsedRange.Find("Isolate AST Results").Offset(2, 0).End(xlDown).Row)).Select