Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > reference to pa...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 30063 of 31576
Post > Topic >>

reference to parent qry

by jan.schaak@[EMAIL PROTECTED] Apr 22, 2008 at 06:50 AM

hi,

this is my sql code.
-----start code-----
SELECT Reeksen.ReeksNR, Reeksen.ReeksText, Count(Strips.Titel) AS
NBTitel,

(SELECT Count(strips.Titel) AS AantalVanTitel FROM (Reeksen INNER JOIN
Strips ON Reeksen.ReeksNR = Strips.ReeksNR) INNER JOIN Pictures ON
Strips.Uniek = Pictures.Uniek where reeksen.ReeksNR=11) AS AantalPic

FROM Reeksen INNER JOIN Strips ON Reeksen.ReeksNR = Strips.ReeksNR
GROUP BY Reeksen.ReeksNR, Reeksen.ReeksText;
-----end code-----

somewhere in the middle I need to reference to Reeksen.ReeksNR, the
first field in the statement. like now I always have the same value
for each row. and it shout be different for every row. if I change it
into Reeksen.ReeksNR it always returns the nubre of all records in the
table. Someone has I solution

Thanks Jan
 




 7 Posts in Topic:
reference to parent qry
jan.schaak@[EMAIL PROTECT  2008-04-22 06:50:47 
Re: reference to parent qry
"JR" <xx.x.x  2008-04-22 18:17:38 
Re: reference to parent qry
Tom van Stiphout <no.s  2008-04-22 19:58:19 
Re: reference to parent qry
Tom van Stiphout <no.s  2008-04-22 22:25:47 
Re: reference to parent qry
"JR" <xx.x.x  2008-04-24 11:59:22 
Re: reference to parent qry
Roger <lesperancer@[EM  2008-04-24 03:38:55 
Re: reference to parent qry
"JR" <xx.x.x  2008-04-24 17:20:11 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 1:46:20 CST 2008.