artful at rogers.com
artful at rogers.com
Fri Feb 23 12:51:04 CST 2007
You have to base the crosstab on the result query from the first operation, so that the parameters are gone, and only their result set left. Then your problem will disappear. Arthur Fuller Technical Writer, Data Modeler, SQL Sensei Artful Databases Organization www.artfulsoftware.com ----- Original Message ---- From: Keith Williamson <Kwilliamson at rtkl.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Friday, February 23, 2007 1:41:47 PM Subject: [AccessD] Crosstab Question Hi all, I have a query with "[Enter Year for Report]" and "[Enter Month for Report]" as criteria for the Year, and Month of the financial data. This works fine, for prompting the user for the info, to filter the data. However, I have also created a crosstab query, based on this query. When I try to run the crosstab, it tells me that the jet database engine does not recognize [Enter Year for Report] as a valid field name. ?? Regards, Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland 21231-3305 410-537-6098 direct | 410-276-2136 fax | www.rtkl.com <http://www.rtkl.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com