I am using a crosstab query, where I have 'Markets' as the columns heading, and 'Casetype' in the rows. And the matching total number of cases (I made the crosstab give count) in the corresponding fields. (This crosstab is based on a query that gives list of all cases with casetype and markets).
I am trying to use a Dlookup to reflect these counts on a textbox in a form. But its showing up a #Name? error.
This is what I did. I put a textbox on a form and in its control source I gave the below code:
=DLookUp("CountOfcasenum","qryCrsCasesByMarkets"," Markets = 'Newyork'" And "Casetype = 'AUTO'")
Is it wrong to give two fields as the criteria? Which is the best way to go ahead with this?