Ars Technica

MS Access Database: Subquery can only return 1 record. Huh?

Can MS Access only return 1 record with a SubQuery?? Or, is this a general rule that applies to SQL?