Jeff,

I have indexed and PK columns in the Access DB as I tried to optimise the query performance, other than having indexes I also split the table into years etc...

Jim,

Thanks for that but with some of the things I need to do, views etc it gets a bit big and messy with Access, I have tried to use it...

I will do that, strangely I need that on my main table, which has just north of 1.1 Million rows at the minute, I did get a program written for...

Yes you did thanks Jeff

I was just going to put it in 2008 unless there are any major bugs.

As mentioned I am going to do a couple of Tutorials to...

Jeff,

Thanks for that I did look it up and probably a dumb question, but joins make it more complex and can take longer, columns make bigger take longer.

I...

Thanks lads its appreciated.

Strangely enough I do need to do running totals so that is really helpful.

I was thinking about "cheating" by putting columns from other tables into the biggest...

David,

Thanks again, I did realise I needed SQL, I did in fact buy a book, yet unopened as I discovered the data was in a real mess, so as the...

David McKinney (3/7/2008)

I've written an article 'Linking to the Previous Row' which illustrates exactly this sort of thing using CTEs (Common Table Expressions).

Unfortunately it's not published yet. (It'll be...