Re: Q: MISC questions

Article View: comp.databases.ms-access

Article #42

Back to comp.databases.ms-access Previous Next

#42

From: Bob Gailer
Date: Tue, 28 Oct 1997 00:00

14 lines
1347 bytes

>In (SELECT [=GetZi()] FROM [Konto] As Tmp GROUP BY [=GetZi()] HAVING 
>Count(*)>1) And Yes
>
>...without getting errors. It seems to me that Access dosn't want any
>function-calls in a querry.

Select can be followed by field names or expressions. A function call
is an expression; you should see the value returned by the function in
each row of the result set. What you can't do have a function supply a
field name to the query. So generate the sql this way:

sql = "(SELECT " & =GetZi() & " FROM [Konto] As Tmp GROUP BY " & _
=GetZi() & " HAVING >Count(*)>1) And Yes"

Technical Details

Message-ID: <3456778c.14324053@news.denver.net>

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

References: <6352mr$cbg@fstgal00.tu-graz.ac.at>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1668c5,17ab5fef9423dcf5,start
X-Google-Attributes: gid1668c5,public
X-Google-Thread: ff0ac,17ab5fef9423dcf5,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f67eb,17ab5fef9423dcf5,start
X-Google-Attributes: gidf67eb,public
X-Google-Thread: 102b1d,17ab5fef9423dcf5,start
X-Google-Attributes: gid102b1d,public
From: ramrom@denver.net (Bob Gailer)
Subject: Re: Q: MISC questions
Date: 1997/10/28
Message-ID: <3456778c.14324053@news.denver.net>
X-Deja-AN: 285646734
References: <6352mr$cbg@fstgal00.tu-graz.ac.at>
Organization: All USENET -- http://www.Supernews.com
Newsgroups: comp.databases.ms-access,at.fido.msaccess,de.comp.datenbanken.ms-access,microsoft.public.de.access

Reply to Parent Message