The table i posted at the start is what the table looks like in SQL.

Sorry, but your anwers made it even more obscure:

What you mean by "the last not null...

What you mean by "the last not null field"?

1. Do you want to select AskSideRWsize if the BidSideRWsize is null?

use ISNULL(BidSideRWsize, AskSideRWsize)

> I want to select only when there is...

So stupid its order by in sql, where i need to do it not in excel

There is one thing, I need the record setto come through sorted from oldest to newest, I have a time stamp or I could add a field that i can...

ok this is working for me thats alot for your replys

rsRecordset5.Open "select ESASKSIZE AS ESASKSIZE,ESBIDSIZE AS ESBIDSIZE from DBO.DEMANDSPREAD WITH (NOLOCK) WHERE ESASKSIZE > '' AND ESBIDSIZE > '' AND...

rsRecordset5.Open "select ESASKSIZE AS ESASKSIZE,ESBIDSIZE AS ESBIDSIZE from DBO.DEMANDSPREAD WITH (NOLOCK) WHERE TIMESTAMP BETWEEN DATEADD(mi, -1, " & "'" & DSMAXTS & "'" & ") AND " & "DATEADD(ss, -1,"...

this worked for me and never any errors

rsRecordset7.Open "select TIMESTAMP from DEMANDSPREAD WHERE TIMESTAMP=(SELECT MAX(TIMESTAMP)FROM DEMANDSPREAD WITH (NOLOCK))", gcnConnect

DSMAXTS = rsRecordset7.Fields(0).Value

...

Further info to my post

This VBA code is on a timed loop, it sends the query to sql every 2 seconds

I am using excel to pull data from SQL on...

1)

rsRecordset7.Open "select TIMESTAMP from DEMANDSPREAD WHERE TIMESTAMP=(SELECT MAX(TIMESTAMP)FROM DEMANDSPREAD)", gcnConnect

DSMAXTS = rsRecordset7.Fields(0).Value

rsRecordset7.Close

2)

sSQL = "select...

I think that would be ok in this instance, any details you know of to guide me through setting one up

I would like to produce a table from it, that...

Cant SQL execute a query when a new record comes in that woukd be simplist of all

I dont chart in excel i chart in a charting package built for realtime data from the stockmartet, excel is just a medium for referencing data

Not exactly sure what you're updating in Excel (e.g. are you retrieving/displaying a rolling history or just a single value?) but anything you can show/display in Excel should be pretty...

I was thinking webpage, but thats a bit later, for now i wanted to concentrate on excel sql, i have 1 sending PC and 4 recieving, excel is ideal because...

I have 1 sending data to excel on a LAN, i then intend to use upto 10 PC's to send queries via excel

I am unsing it for stockmarket data analysis...