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("","CrosstabPHXAMA","Year = " & [year])
2-in SQL view
DLookUp("","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.