Recent content by lcfc

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?