Once I have filled a dataset is there a set of properties or in-line functions that will allow me to pull the data out of said dataset without having to populate a datagrid?

Code example:
Code:
        Connection.Open()
        accCommand.CommandText = "SELECT CustID FROM Rental WHERE DvdID = " & DvdID
        accCommand.Connection = Connection
        dvdDataAdapter.SelectCommand = accCommand
        accCommand.ExecuteNonQuery()
        dvdDataAdapter.Fill(dvdDataSet, "CustID")
        Connection.Close()
I know the information returned from the query is a single value located at (0, 0) I just can't get to it so I can assign the value to the variable. I wouldn't be doing this if I could nail down the syntax for a nested query in Access 2007. Any suggestions?

Thanks guys.