ACC1x: Domain Param. of Domain Function Cannot Be SQL Exp.

• Microsoft Access versions 1.0, 1.1

SYMPTOMS

If you try to use an SQL SELECT statement as the domain parameter of a domain function, error 3078 is displayed:

   Couldn't find input table or query <SQL string>

   Couldn't find input table or query "Select * From Table1 Where ID =
   1"

RESOLUTION

Microsoft Access "Language Reference," versions 1.0 and 1.1, and Microsoft Access Help version 1.0 incorrectly suggest that the domain parameter of a domain function (for example, the DLookup(), DFirst(), DLast(), DSum(), DMax(), DMin(), and DCount() functions) can be an SQL expression.

The following is the incorrect description of the domain parameter:

   String expression identifying the records that constitute the
   domain. It can be a table name, a query name, or an SQL
   expression that returns data.

   String expression identifying the records that constitute the
   domain. It can be a table name or a query name.