return values off recordset

[gsc123]

If i use this query

SELECT TOP 2 bidhistory.bidAmount AS price FROM bidhistory WHERE (((bidhistory.idProduct)=1560) AND ((bidhistory.idCustomerBid)<>15)) ORDER BY bidhistory.bidAmount DESC


how do I get both values? or specify a particular value... ie; I want the second one

 

[vicvirk]

You need to select them, ie if you have a table that looks like this:

Name: tblMyTable
Field1: dataId
Field2: dataOne
Field3: dataTwo
Field4: dataThree

And try this:

select dataOne from tblMyTable where dataThree = myValue order by dataTwo asc

It won't work as all you are selecting is dataOne but trying to add a condition to dataThree and sorting by dataTwo.

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc

 

[gsc123]

if I was to directly access 2nd field how would I grab it