Hi,

does anyone have a simple example, or know where to find one, for the following:


* Using an SQL statement to retrieve data from a table
* being able to explicitly say which field you wish to see (like the old recordset.fields("fieldname") method

all the examples i can find only relate to SQL server and not to access.

thanks all