Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. frankiem

    how to convert color lines to black and white solid and dashed lines?

    Brilliant. Thanks.
  2. frankiem

    how to convert color lines to black and white solid and dashed lines?

    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...
  3. frankiem

    Summing Sequential Records

    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...
  4. frankiem

    Summing Sequential Records

    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...
  5. frankiem

    Time difference Query

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

    Summing Sequential Records

    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...
  7. frankiem

    Summing Sequential Records

    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...
  8. frankiem

    List of fieldnames

    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.
  9. frankiem

    Excel size limit problem

    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...
  10. frankiem

    Time Series Problem

    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...
  11. frankiem

    Time Series Problem

    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...

Part and Inventory Search

Back
Top