Re: crosstab query

Article View: comp.databases.ms-access

Article #452

Back to comp.databases.ms-access Previous Next

#452

From: gwalsh
Date: Tue, 05 Aug 1997 00:00

19 lines
2052 bytes

marcel sporck wrote:
> 
> 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

The reason that Access can't bind the name is because it has a space in
it and parentheses. Remove them and there should be no problem. Also the
form must be open before the query is run. If DAYREPORT(SELECTION) is
not part of the form name, rather some kind of function, then you have
got it in the wrong place.

Good Luck!
-Jer

Technical Details

Message-ID: <33E7F06D.1E9E@net999.com>

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: fe218,90d6690106f35c87
X-Google-Attributes: gidfe218,public
X-Google-Thread: ff0ac,90d6690106f35c87
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 111a5a,90d6690106f35c87
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1034e6,90d6690106f35c87
X-Google-Attributes: gid1034e6,public
X-Google-Thread: 102b1d,90d6690106f35c87
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 1142f6,90d6690106f35c87
X-Google-Attributes: gid1142f6,public
X-Google-Thread: 10bb27,90d6690106f35c87
X-Google-Attributes: gid10bb27,public
From: gwalsh <gwalsh@net999.com>
Subject: Re: crosstab query
Date: 1997/08/05
Message-ID: <33E7F06D.1E9E@net999.com>
X-Deja-AN: 262591415
References: <01bca10b$9d747ae0$0b904ac1@pin14412.ping.be>
Organization: A News Reader at ATMNet
Reply-To: gwalsh@net999.com
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