Query problem...!

  • Thread starter Thread starter explode
  • Start date Start date
E

explode

I made an access database 4 tables with relationships.
Tables are
Studenti (StudentID (primary key), Broj iksice,Prezime,Ime)
Kolegiji (KolegijID(primary key), Ime kolegija)
Predavanja (PredavanjaID (primary key),Datum)
Spoj (StudentID ,PredavanjaID ,KolegijID )

Relationships are:
Studenti(StudentID)->Spoj(StudentID)
Kolegiji (KolegijID)->Spoj (KolegijID)
Predavanja (PredavanjaID)->Spoj (PredavanjaID)

I made in access this query by dragging columns:

TRANSFORM Count(Spoj.PredavanjaID) AS CountOfPredavanjaID
SELECT Spoj.StudentID, Studenti.Prezime, Studenti.Ime
FROM Studenti INNER JOIN (Predavanja INNER JOIN (Kolegij INNER JOIN
Spoj ON Kolegij.KolegijID=Spoj.KolegijID) ON
Predavanja.PredavanjaID=Spoj.PredavanjaID) ON
Studenti.StudentiID=Spoj.StudentID
WHERE (((Kolegij.KolegijID)=2))
GROUP BY Spoj.StudentID, Studenti.Prezime, Studenti.Ime
PIVOT Predavanja.Datum;

In access everything is working fine but in VB2005 Tableadapter can
not recognize Transform and Pivot.I'm useing Access 2003 database
Kolegij.KolegijID can be any positive integer.
Help...!
Thank you!
 
I made an access database 4 tables with relationships.
Tables are
Studenti (StudentID (primary key), Broj iksice,Prezime,Ime)
Kolegiji (KolegijID(primary key), Ime kolegija)
Predavanja (PredavanjaID (primary key),Datum)
Spoj (StudentID ,PredavanjaID ,KolegijID )

Relationships are:
Studenti(StudentID)->Spoj(StudentID)
Kolegiji (KolegijID)->Spoj (KolegijID)
Predavanja (PredavanjaID)->Spoj (PredavanjaID)

I made in access this query by dragging columns:

TRANSFORM Count(Spoj.PredavanjaID) AS CountOfPredavanjaID
SELECT Spoj.StudentID, Studenti.Prezime, Studenti.Ime
FROM Studenti INNER JOIN (Predavanja INNER JOIN (Kolegij INNER JOIN
Spoj ON Kolegij.KolegijID=Spoj.KolegijID) ON
Predavanja.PredavanjaID=Spoj.PredavanjaID) ON
Studenti.StudentiID=Spoj.StudentID
WHERE (((Kolegij.KolegijID)=2))
GROUP BY Spoj.StudentID, Studenti.Prezime, Studenti.Ime
PIVOT Predavanja.Datum;

In access everything is working fine but in VB2005 Tableadapter can
not recognize Transform and Pivot.I'm useing Access 2003 database
Kolegij.KolegijID can be any positive integer.
Help...!
Thank you!
Click to expand...

I'm not to sure about how to get the tableadapter to recognize
transform and pivot, but why don't make your query into a SELECT ...
INTO query and read the newly created table into your tableadapter?

Thanks,

Seth Rowe
 
Back
Top