Microsoft KB Archive/101088

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:43, 20 July 2020 by X010 (talk | contribs) (Text replacement - ">" to ">")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.