VB.net Access SQL Select an example of data in any column

Hi

In my VB.net application that works with an Access database, I need to get a single example of data
for each column. What SQL statement would I use to get a single item of data that is not null
from any column?

For instance if I have a Text column called AccNumber I would want to get a single example of data eg "ACC123"

The following statement gets me a list, when I just need one of these items
SELECT ([AccNumber]) AS Expr1
FROM Transactions
WHERE [AccNumber] Is Not Null;