Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

crosstab-query

20 views
Skip to first unread message

Filips Benoit

unread,
Dec 10, 2009, 1:45:17 PM12/10/09
to
Dear All,

Opening Qry_CrossTab_1MonsterLocatie from cmd in FRM_MONSTER_LOCATIES
triggers error:

Microsoft Jet database engine does not recognize
'[Forms]![FRM_MONSTER_LOCATIES]![MonsterLocatieId]' as a valid field or
expression
I inserted the parameter with the expressionbuilder !

Another query ( selectquery) having the same parameter works fine!

Why ???

See sql below


TRANSFORM First(TBL_ANALYSE_TEST_MAP.TestResultaat) AS FirstOfTestResultaat
SELECT TBL_ANALYSE.AnalyseLaboRef
FROM TBL_TEST INNER JOIN (TBL_ANALYSE INNER JOIN TBL_ANALYSE_TEST_MAP ON
TBL_ANALYSE.AnalyseID = TBL_ANALYSE_TEST_MAP.AnalyseID) ON TBL_TEST.TestID =
TBL_ANALYSE_TEST_MAP.TestID
WHERE
(((TBL_ANALYSE.AnalyseMonsterLocatieID)=[Forms]![FRM_MONSTER_LOCATIES]![MonsterLocatieId]))
GROUP BY TBL_ANALYSE.AnalyseLaboRef
ORDER BY TBL_ANALYSE.AnalyseLaboRef
PIVOT TBL_TEST.TestNaamNED;

Filip


Filips Benoit

unread,
Dec 10, 2009, 1:57:03 PM12/10/09
to
Solution > http://support.microsoft.com/kb/209778

"Filips Benoit" <benoit...@telenet.be> wrote in message
news:lobUm.1963$ra....@newsfe26.ams2...

0 new messages