Recent content by frankiem

Brilliant. Thanks.

Does anybody know of a way to convert an image of a graph with 3 colored lines (red, green and blue on a white background with black X and Y axes) into a black and white graph with solid, dashed and dotted lines? I only have a .png image of these graphs as I lost the raw data in a recent hard...

DeGeneral, That's is exactly it! When I started to work on this query a few weeks ago, I started with subqueries. But they didn't work. Little by little, I changed things until I got the query to work. My query does work - but not all of the time. I can't seem to systematically get it to start...

Sorry, didn't recognise 'ct' as 'copy of table' (Duh!). This codse only works for small numbers of records (less than a few thousand). For tables like I'm working on (often with over a million records), it's very slow and causes ACCESS to hang. I have 512MB of RAM on my PC, so I don't think...

For 10 minute groupings, you could use: select Left([TimeOrdered],4) from orders groupby Left([TimeOrdered],4);

swampBoogie, Do you mean to put this code inside a VB loop, resetting ct each time? I have several million records in these tables, so I am hoping to find a quicker method than that. My SQL code is pretty quick - when it works! It just doesn't work all the time, i.e. it will work maybe 1 time...

I am trying to sum sequential records in a table. My data looks like: [change] [count] 0 0 1 1 1 2 0 2 0 2 1 3 0 3 1 4 The [count] field is initially blank. I set [count] for record 1 to 0. Then, I...

Does anybody know of a way to get the list of field names in an Access table using SQL or VB? I want to be able to load a list box with the field names when one of a group of tables is selected.

I am using Excel 2000. I have raw data in 60,000 rows and 7 columns in one sheet. In another sheet, I am trying to copy down some formulas that relate to the first sheet. I can copy down as far as row 47,000. When I try to copy below this, even is small chunks, I get a message saying that my...

Thanks for the feedback guys. I figured out a solution along the lines that MichaelRed suggested. It proved very longwinded but it works. It uses temporary tables and then updates a new column in the original table. I tried using subqueries but this just caused my PC to stall - the table has...

I have a very large table of stock price data, which shows all the prices that occured over a year, timestamped to the nearest second. There are three type of prices -"Trade" which is the price that occured when a trade was agreed, "Ask" which is an unexecuted quote price at...