RANDALL R ANTHONY
RRANTHON at sentara.com
Fri Sep 11 09:08:04 CDT 2009
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/ )