Microsoft KB Archive/101088

{|
 * width="100%"|

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

 * }

Q101088

-

The information in this article applies to:


 * 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 

where  is the SQL string you have entered, such as the following:

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.

The correct wording is provided in Microsoft Access Help version 1.1. The following is the correct description of the domain parameter:

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

Keywords : kbprg kbusage

Issue type :

Technology :