googled already bad connection yesterday anyways got it already just now tnx

Here's another free .NET chart control. The charts look great, comes with plenty of examples, it's very stable, and development/support is active. I highly recommend it. http://zedgraph.org[^]

It works. I just showed you how to use it. You saw the Item property come up because the ExecuteReader method returns an OleDbDataReader object, which is the thing exposing the Item property. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

You could try doing a SHA1 hash on it. There's C++ code that does it on CP but I'm not sure about VB/VB.NET. Steve

ty ty

Join in the B table and filter out the dates after the specified date. Group by the fields in the A table and use max() to get the latest date from the B table. --- b { font-weight: normal; }