Search results for query: *

I solved it, in case anybody wants to know. Place 2 charts over the top of each other, with different lenght moving averages, then set the top one to transparent. Cheers

Hi there, I have a line chart and would like to overlay 2 moving averages, a fast and slow moving one. I can only appear to make one trendline appear, even when i put the value in twice? Is their any solution?

Hi, we are trying to create an Statistical Process Chart in Crystal. We have created several formulae to calculate the average moving range and upper and lower limits. The average moving range forumla involves using a variable and therefore will not allow us to chart it or its dependants. Is...

Hi, below is the SQL from a query we are trying to run. There are many entries in the field LH_TIME_OUT, but we need it to select only the last date (BTW it is a datetime field). We have tried putting max in the 'total' row, but this does not work. Can anybody help: SELECT...

Hi thanks for responding. It is not a line chart, but a bar. The null values just leave a 'blank' column

Can anybody tell me how to supress null values in a chart?

Hi, I am getting very confused, so need some help! I have 3 combo boxes. When a user picks from the first box, this needs to limit the options in the 2nd box. Then when the user selects an option from the 2nd box, this will limit the options in the third box. At the moment i have a main...

Can anybody tell me how i can put times into categories? I need a macro that will put a time in a category say if it between 00:01 and 01:00 or 01:01-02:00, etc. Is this possible?

Hey that worked a treat, many thanks

In this field - [Time Arrive to Dr] Thanks

I am using this code to obtain the median from a field: SELECT Min([Time Arrive to Dr]) FROM [All] WHERE [Time Arrive to Dr] IN (SELECT TOP 50 PERCENT [Time Arrive to Dr] FROM [All] ORDER BY [Time Arrive to Dr] DESC) UNION SELECT Max([Time Arrive to Dr]) FROM [All] WHERE [Time Arrive to Dr]...

Could you show me, in this query, I have tried but cannot seem to work it out?

I am using this code to obtain the median from a field: SELECT Min([Time Arrive to Dr]) FROM [All] WHERE [Time Arrive to Dr] IN (SELECT TOP 50 PERCENT [Time Arrive to Dr] FROM [All] ORDER BY [Time Arrive to Dr] DESC) UNION SELECT Max([Time Arrive to Dr]) FROM [All] WHERE [Time Arrive to Dr]...

Hi, I have used bitblt to draw a clear rectangle over a blured image. The application works well, but i would like to change the shape of the rectangle to a circle, is this possible? (see here: http://ibs.derby.ac.uk/avru/test/bitblt.jpg for a picture)Below is my code, can anybody help...

Hi i am new to Java, from a vb background. I am trying to find an example applet that i can play with, that is the opposite of this: http://www.anfyteam.com/anj/lens/anlens.html i.e. the lens is clear and the background is blurred. Can anybody point me in the right direction?

When you click on this link http://ibs.derby.ac.uk/avru it takes you to http://ibs.derby.ac.uk/avru/index.htm (the frameset). The mainFrame in the frameset is home.htm. To stop search engines only finding home.htm and loosing the frames i am using a script that rebuilds the index.htm frameset...

>Are you worried about them being able to click "back" and >get where they came from? Yes that is exactly it!!

When somebody links to the webpage from a framed site (like the example) it creates an error, therefore i was trying to 'bust' the frames when my site loads. I think the origional error occured because i am using a script that rebuilds the frames around orphan pages. click the example above...

Thanks for the reply. When i click back now it just seems to refresh the current page. To see what i mean try the example again.

Hi i use a piece of script that allows my page to break out of other peoples frames: <SCRIPT> <!-- if (self != top){ if (document.images) top.location.replace(self.location); else top.location = self.location;} // --> </SCRIPT> This works great, but if i click back, doesn't keep the...