Assuming the query is meant to return a single value - and if it doesn't, you need to change it so it does - then don't use a data adapter at all.
Instead, use an OleDbCommand, and call ExecuteScalar:
OleDbCommand.ExecuteScalar Method (System.Data.OleDb)[
^] - it returns the single value directly, and you can just cast it to a number and do what you want with it.