Keith Williamson
Kwilliamson at RTKL.com
Fri Feb 23 12:50:39 CST 2007
Oops. Nevermind. :) Discovered adding parameters in my crosstab properties. Unless someone else has other advice. 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson Sent: Friday, February 23, 2007 1:42 PM To: Access Developers discussion and problem solving 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