I cannot find anything in the help files to assist me with computed columns
in a Access Queries using adp/SQL. For example when using Access (mdb) I
could put Member:iif([Paid]0,"YES","NO"), which would result in a column
called Member with a value of either Y or N depending on the value of [Paid].

This cannot be done using adp/SQL. The query designer simply puts quotes
around the entire statement and outputs that. Please could you tell me where
I can I find a useful reference guide that will tell me how to construct
computed columns in Access queries using adp/SQL?

Many Thanks
Ian