[AccessD] Crosstab Querry with parameter on Form (A97)

Steve Grant steve.grant at stgsolutions.com
Mon Mar 10 08:20:00 CST 2003


Hi Doris,

I tried with all dots and then with all bangs and I get the same error msg.

Steve

-----Message d'origine-----
De : accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]De la part de Mike and Doris
Manning
Envoye : Monday, March 10, 2003 09:00
A : accessd at databaseadvisors.com
Objet : RE: [AccessD] Crosstab Querry with parameter on Form (A97)


Sounds like mixed dot (.) and bang (!) operators.

Try...

Between [forms]![frm_Param]![txt_StartInvoiceDate] And
[forms]![frm_Param]![txt_EndInvoiceDate]

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Steve Grant
Sent: Monday, March 10, 2003 08:40 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Crosstab Querry with parameter on Form (A97)


Access 97

Hi all,

I am running into a problem that eludes me.

I have a query that uses a form to get it's parameters.
This is what's in the criteria section of the query.
Between [forms].[frm_Param]![txt_StartInvoiceDate] And
[forms]![frm_Param].[txt_EndInvoiceDate]

When I run that query, everything works fine, i.e. the correct records are
displayed.

But, when I use that query in a crosstab query, I get the following error
msg:
"The Microsoft Jet Database engine does not recognise
[forms].[frm_Param]![txt_StartInvoiceDate]
as a valid field or expression."

The crosstab query works fine if I use dates instead of a reference to a
field on a form. So if I put: Between #01/01/2003# And #01/31/2003# in the
non crosstab query, the crosstab query works fine.

I tried putting the criteria directly in the crosstab query and I get the
same error msg.

Anyone as an idea why this is hapening?

Thanks,


Steve


_______________________________________________
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






More information about the AccessD mailing list