Article View: comp.databases.ms-access
Article #454Re: crosstab query
From: Ron Myer
Date: Fri, 08 Aug 1997 00:00
Date: Fri, 08 Aug 1997 00:00
16 lines
2008 bytes
2008 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.11The Error more than likely has to do with the Parentheses. (SECTION). Can't you come up with a simpler field name on your form? -- Will accept programming assignments in Access 2.0 or '97. Single problems to complete applications. Send requirements for a quote. Ron Myer
Technical Details
Message-ID:
<33EB0052.5BB0@ix.netcom.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<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: ff0ac,90d6690106f35c87 X-Google-Attributes: gidff0ac,public X-Google-Thread: 1034e6,90d6690106f35c87 X-Google-Attributes: gid1034e6,public X-Google-Thread: 1142f6,90d6690106f35c87 X-Google-Attributes: gid1142f6,public X-Google-Thread: 10bb27,90d6690106f35c87 X-Google-Attributes: gid10bb27,public X-Google-Thread: fe218,90d6690106f35c87 X-Google-Attributes: gidfe218,public X-Google-Thread: 102b1d,90d6690106f35c87 X-Google-Attributes: gid102b1d,public From: Ron Myer <myeron@ix.netcom.com> Subject: Re: crosstab query Date: 1997/08/08 Message-ID: <33EB0052.5BB0@ix.netcom.com> X-Deja-AN: 262852461 References: <01bca10b$9d747ae0$0b904ac1@pin14412.ping.be> To: marcel sporck <marcel.sporck@ping.be> Organization: Energy Masters 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