[AccessD] Crosstab uses form criteria not

Right. It's kinda weird, but for crosstabs you have to tell it about the parameters on the query menu, but still use the criteria row like a normal query.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Monday, June 21, 2010 9:48 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Crosstab uses form criteria not

Did you mean to then use the parameters as usual in the top row of the qbe and with the form reference in the criteria? 
Just the addition of adding to the parameter list?

Thx

Bob

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Tuesday, June 15, 2010 1:34 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Crosstab uses form criteria not

The short answer is yes, Jet treats crosstabs slightly differently.

You need to open the query in design view and then from the 'Query' menu select 'Parameters'. You will get a little dialog box where you have to enter the names of the parameters and the data type.

HTH

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Tuesday, June 15, 2010 3:56 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Crosstab uses form criteria not

Hello to the list,

I have a query that uses a couple of references to controls on a form to limit the date range for criteria.
It works just fine.

When I try to use the same query as a source for a second query (crosstab), Access barfs and says:
"The Microsoft jet database engine does not recognize '{Forms]![frmReports]![cboMonths]' as a valid field name or expression"

Does not the same jet engine work the same when creating a crosstab?

Thanks in advance,

Bob Heygood


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com