Syntactical Problems (I suppose)

  • Thread starter Thread starter stefanbienk
  • Start date Start date
S

stefanbienk

Hi,

I'm just getting started with Access for a project,
and having some problems conercerning queries:
I prefer hand-coding SQL-statements instead
of using the assistants, so I typed the following
(on the famous Nordwind.mdb):

SELECT Artikel.[Kategorie], Count(Artikel.[Artikel-Nr]) AS n
FROM Artikel
GROUP BY Artikel.[Kategorie];

The problem:
when executing the query, I'm prompted to input
a parameter named "Artikel.Kategorie"....

what's up here? the field Artikel.Kategorie exists
in the table Artikel!

Could somebody help me please??

Thanks for help,
Stefan
 
As much as you prefer the hand-typing method, it can lead to types. Switch
to the design view of the query (not the 'Assistants'. which I think are the
Wizards), and see if there is anything strange there.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top