Recent content by Sideline

test_data is in MS Access stand alone inner query returns 10 rows but when the inner query is placed between ( and ) it throws the error above. thx

Skipvought, in ms query Transform Sum(test_Data.Elapsed_Time)/Count(*) as ET Select test_Data.Weekday, test_Data.Class From ( Select test_Data.Weekday, test_Data.Hour, test_Data.Date, test_Data.Class, SUM(test_Data.[Elapsed Time]) as ET From test_Data test_Data Group by test_Data.Weekday...

Skipvought, apologies for mis-spelling your nick. I tried to use your suggested sql without success. The sub-query would not work. The good news is another forum suggested the use of {= SUM(IF(FREQUENCY(IF((A2:A14=1)*(B2:B14=1),C2:C14),C2:C14)>0,1))} This allows for a change in the criteria...

Skipcought, all of that is already in place for the original dataset. However, one limitation of running an aggregation at the database level is not having the capacity to modify the denominator to include other dimensions from the dataset. ie from the example dataset below Weekday = 1, Hour...

One last comment. It would be cool to be able to do this within the workbook without having two distinct datasets which would blow the file size out. thx

thx skipvought, I have spent too much time in the forrest. Aggregating the data by hour, weekday and date would solve the problem. Will do in the database and let you know how I get on. cheers

SkipVought, you are correct if the denominator is the number of dates for that combination of hour and weekday; which is 7. However for the example above, day 1 hour 1, there are 7 records, but only 5 distinct dates. There are two records for each of 08/03/09 and 09/03/09. Thus the...

SkipVought, thanks for the quick response. each row in the actual dataset has a date time stamp which is converted using the weekday and hour functions. Hence the data set has many event instances for each weekday (1- 7) and each hour (0 - 23). in the hypothetical data set above the last event...

Dear All, This has me stumped and I would very much appreciate any suggestions. Dataset is 220K rows. An small subset follows. Using an array calc with criterions Day = 1 and Hour = 1 summed on Elapsed Time returns 81 with an average of 11.57 for 7 events of which there are 5 distinct dates...

As an update my iMac died (blown logic board) about 2 weeks post this thread. Purchase of a new machine with 10.5 solved the problem. Not sure if it was the new os x of a config change but all is great now. cheers

Dear All I am trying to use rdp for a xp machine using citrix ICA client for mac os x 10.4. However, when the 'log on to windows' appears the keyboard is unresponsive. I can not enter a password to access the xp desktop. Using options at the remote desktop connection dialogue box allows me...

But then again there is nothing like self help! SELECT Transformation.Theatre, Transformation.[Op Date], Transformation.[Operation Id], [qry NT 1]![Anaes Start]-IIf(IsNull([qry NT 2]![Surg Fin]),0.3541661,[qry NT 2]![Surg Fin]) AS [Start Delay], Transformation.Year, Transformation.Month...

Thanks for the feedback Remou. As indicated in the initial post I was unsure on how to get this started using sql as opposed to the access query gui. A colleague created the following, using sql server, and I will now have a go at translating this into a code which I can use in access. If...

I have little sql experience beyond the access gui and would appreciate any tips on how to get this started. Based upon my event dataset I need to create a query which returns for each day the first event of each day in the dataset based upon a data/time criteria. That criteria is a) the first...

Tim, Did you get a solution for this problem? I posted the following in remote access forum without reply. Any thoughts thx Richard Apologies if my terminology is astray. I am using IE on OS X attempting to log into my Windows XP profile at work and I get the following error when I try to...