Search results

Hi, I have managed to successfully get the CondMedian funtion to work directly off a table, no problems. However, i have a form into which i can select start & end dates to query a specific time period and subset of the data. I thin try run a new query on this subset with the CondMedian...

I have been struggling with getting the syntax right for the ConcatRelate function. I have looked at other peoples examples and mine seems to have exactly the same syntax but it is giving me an error. My Sql is SELECT qr_RiverGroup.River, ConcatRelated("Site_ID","qr_RiverGroup","[River] = '" &...

Hi, I have a chart in a form which gets its data from a cross-tab query. The chart was working fine and still is besides the fact the it is skipping the first row of data, or reading/treating it as a header. I had this problem before and the only way i could get around it was to re-create the...

Hi, I have set up a form on which there is a graph which draws data from a query. I have set up a text boxes to take in the Y axis min, max and interval values so the user can customize the graph according tot he range coming out of the query. This all works fine and is perfect, however, i also...

Hi i am trying to run a cumulative total for each month spanning different years. unfortunately i cannot get the order correct for the DSum calculation as it orders by month only and i cannot figure out how to order by year and month. I thought about adding in a temporary sequential number and...

Hi, I have some charts for which i have set up text boxes to specify the max and min y axis values as well as the major unit increment. This works well and i am happy with it. However, i would like to have the option to reset the charts to autoscaleing via a command button. I have set up...