Here is a line of code from a function from an MS Access 2000 DB I am working on.
VB Code:
  1. DoCmd.RunSQL "ALTER TABLE tester ADD Notes memo"
I know I can use VarChar, Int, Currency, and probably others.

Q1. Where can I see a full list of types I can use?
Q2. Failing that any one know what the type is for a Yes/no (boolean) field is?