Re: crosstab query

Article View: comp.databases.ms-access

Article #453

Back to comp.databases.ms-access Previous Next

#453

From: Michel Walsh
Date: Tue, 05 Aug 1997 00:00

22 lines
2013 bytes

Hi Marcel,

Have you define it as a parameter? It happens often that a problem like
that, in crosstab, is related to the fact that such parameter must be
correctly "type"d.

Hope it may help,
Vanderghast, Access MVP

marcel sporck <marcel.sporck@ping.be> wrote in article
<01bca10b$9d747ae0$0b904ac1@pin14412.ping.be>...
> i have to make some crosstab queries but i have a little problem : i need
> to use a criteria that comes from a form but that simply doesn't work
(and
> i know why !).  I would like to use the something like this
> "[Forms]![SY_ASS DAYREPORT(SELECTION)]![Field33]" but i always have the
> following error : can't bind name.  When i use it with a normal query
there
> is no problem.  Who can help me (i need tha criteria !!!).
> PS : access 2.0 with win 3.11
>

Technical Details

Message-ID: <01bca189$146cd700$c7eac28e@vangerdahast>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <01bca10b$9d747ae0$0b904ac1@pin14412.ping.be>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,90d6690106f35c87
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,90d6690106f35c87
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1034e6,90d6690106f35c87
X-Google-Attributes: gid1034e6,public
X-Google-Thread: ff0ac,90d6690106f35c87
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10bb27,90d6690106f35c87
X-Google-Attributes: gid10bb27,public
X-Google-Thread: fe218,90d6690106f35c87
X-Google-Attributes: gidfe218,public
X-Google-Thread: 1142f6,90d6690106f35c87
X-Google-Attributes: gid1142f6,public
X-Google-Thread: 102b1d,90d6690106f35c87
X-Google-Attributes: gid102b1d,public
From: "Michel Walsh" <Vanderghast@msn.com>
Subject: Re: crosstab query
Date: 1997/08/05
Message-ID: <01bca189$146cd700$c7eac28e@vangerdahast>
X-Deja-AN: 262714688
References: <01bca10b$9d747ae0$0b904ac1@pin14412.ping.be>
Organization: Le Groupe Tecnum
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.devtoolkits,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.macros,microsoft.public.access.queries,micros

Reply to Parent Message