<div>
To add to what LSM said, *never* use a domain function in a query. &nbsp;It's equivalent to using a subselect (which you could write directly in the SQL statement), but it is totally un-optimizable by the query parser. &nbsp; &nbsp;If you use a Dlookup(), DCount(), etc in a query, your destined for poor performance from the start.<br />
No points here please.<br />
JimD.<br />

</div>


To add to what LSM said, *never* use a domain function in a query.  It's equivalent to using a subselect (which you could write directly in the SQL statement), but it is totally un-optimizable by the query parser.    If you use a Dlookup(), DCount(), etc in a query, your destined for poor performance from the start.
No points here please.
JimD.


<div>
<div class="content wysiwyg-content">
I am trying to use a select query to analyze annual data records from crosstab query of values grouped at the intersection of column (field number) and row (year). &nbsp;<br />
<br />
The Dlookup syntax follows: &nbsp;<br />
<br />
1-from query design view:<br />
606: DLookUp(&quot;[606]&quot;,&quot;CrosstabP<wbr />HXAMA&quot;,&quot;Ye<wbr />ar = &quot;&nbsp;&amp; [year])<br />
<br />
OR <br />
2-in SQL view<br />
<br />
DLookUp(&quot;[606]&quot;,&quot;CrosstabP<wbr />HXAMA&quot;,&quot;Ye<wbr />ar = &quot;&nbsp;&amp; [year]) AS 606<br />
<br />
The goal is to order it by year to combine with other data fields summed by year. &nbsp;I am having difficulty getting the operation to run efficiently.<br />
<br />
Thanks for any tips on simplifying this to avoid bogging down. &nbsp;**When I run the query, it freezes when reaching the field generated by this syntax.
</div>
</div>


I am trying to use a select query to analyze annual data records from crosstab query of values grouped at the intersection of column (field number) and row (year).  

The Dlookup syntax follows:  

1-from query design view:
606: DLookUp("[606]","CrosstabPHXAMA","Year = " & [year])

OR 
2-in SQL view

DLookUp("[606]","CrosstabPHXAMA","Year = " & [year]) AS 606

The goal is to order it by year to combine with other data fields summed by year.  I am having difficulty getting the operation to run efficiently.

Thanks for any tips on simplifying this to avoid bogging down.  **When I run the query, it freezes when reaching the field generated by this syntax.

Dlookup efficiency in MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.