Microsoft KB Archive/101088: Difference between revisions
m (Text replacement - """ to """) |
m (Text replacement - ">" to ">") |
||
(One intermediate revision by the same user not shown) | |||
Line 27: | Line 27: | ||
<blockquote><div class="ERRORMESSAGE"> | <blockquote><div class="ERRORMESSAGE"> | ||
Couldn't find input table or query | Couldn't find input table or query <SQL string> | ||
</div></blockquote> | </div></blockquote> | ||
<br /> | <br /> | ||
where | where <SQL string> is the SQL string you have entered, such as the following:<br /> | ||
Latest revision as of 17:43, 20 July 2020
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 <SQL string>
where <SQL string> 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 :
Last Reviewed: November 4, 2000 |