🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #454

Re: crosstab query

#454
From: Ron Myer
Date: Fri, 08 Aug 1997 00:00
16 lines
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-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: 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