crosstab query

Article View: comp.databases.ms-access

Article #450

Back to comp.databases.ms-access Previous Next

#450

From: marcel sporck
Date: Mon, 04 Aug 1997 00:00

9 lines
1669 bytes

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: <01bca10b$dc4edf80$0b904ac1@pin14412.ping.be>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,90d6690106f35c87,start
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,90d6690106f35c87,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1034e6,90d6690106f35c87,start
X-Google-Attributes: gid1034e6,public
X-Google-Thread: ff0ac,90d6690106f35c87,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: fe218,90d6690106f35c87,start
X-Google-Attributes: gidfe218,public
X-Google-Thread: 10bb27,90d6690106f35c87,start
X-Google-Attributes: gid10bb27,public
X-Google-Thread: 102b1d,90d6690106f35c87,start
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 1142f6,90d6690106f35c87,start
X-Google-Attributes: gid1142f6,public
From: "marcel sporck" <marcel.sporck@ping.be>
Subject: crosstab query
Date: 1997/08/04
Message-ID: <01bca10b$dc4edf80$0b904ac1@pin14412.ping.be>
X-Deja-AN: 262334397
Organization: EUnet Belgium, Leuven, Belgium
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