[AccessD] Crosstab Query - Additional Parameter

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Fri Sep 11 09:17:35 CDT 2009


Can you post the SQL? 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of RANDALL R ANTHONY
Sent: Friday, September 11, 2009 10:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Crosstab Query - Additional Parameter

Max,
I'm not getting that far, where I'm stuck at is what to put in the query.  If I put the field name in the query, Region as a group by, when I run the report the query is prompting me to enter the Region, ie, it doesn't recognize the table value.  I can't put the Region as a Where in the query grid.

>>> On 9/11/2009 at 9:51 AM, in message <cda8f54e0909110651y644b4f8frc6ced24c4c3a9e96 at mail.gmail.com>, Max Wanadoo <max.wanadoo at gmail.com> wrote:
Could you try this, perhaps:-

sWhere=nz(sWhere,"")
DoCmd.OpenReport sObjName, acViewPreview, , sWhere, , strSvcRegion & "~" & strLocality

This will ensure that sWhere is not null before the docmd is activated.

Max


On 9/11/09, RANDALL R ANTHONY <RRANTHON at sentara.com> wrote:
> Hi y'all,
> I've got a crosstab query that works great.  However, I need to pass 
> an additional parameter (that may or may not be null) and thought I 
> could just add them to the query grid.  This does not work.  I'm 
> assuming that it has something to do with not being part of the 
> columns displayed.  What do I need to do?
>
> DoCmd.OpenReport sObjName, acViewPreview, , sWhere, , strSvcRegion & 
> "~" & strLocality
>
> Is the command, sWhere = "" or 2
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com ( 
> http://www.databaseadvisors.com/ )
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com ( 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