Bob Hovious (4/11/2009)

---

Your first example confuses me a little. (Why 42d and not 42e? Typo?)

However, if you are only wanting to get one single row back...

Thanks Guys,

Jeffrey's answer did the job.

Next time I'll do my homework regarding how to post to this forum .

Regards

Nir

Hi Mohit,

Thanks for your reply

The Table has more fields which I need in my query .

They should be taken from the right record as in that example

Table records

A B...