New to Access-many years with Excel (1 Viewer)

fkvice

New member
Local time
Today, 08:13
Joined
Jun 16, 2012
Messages
3
New to Access - many years with Excel. Having a slow start with an error message saying "Cannot repeat table name "..." in FROM clause. Not sure where to correct it.
 

siddhanth

New member
Local time
Today, 08:13
Joined
May 13, 2012
Messages
4
can you paste your query in sql view here please. if you have multiple table you can create alias of it. example Table A as Tb1
 

fkvice

New member
Local time
Today, 08:13
Joined
Jun 16, 2012
Messages
3
Here it is:
SELECT Tripname.Tripname, Tripdate.Tripdates, [Conf#].[Conf#], [Etkt#].[Etkt#], Daysofweek.Daysofweek, [DateTravel] AS Expr1, [FF#].[FF#], [Flight#].[Flight#], Airlines.Airlines, TimeDeparture.Departuretime, TimeArrival.Arrivaltime
FROM TimeArrival INNER JOIN (TimeDeparture INNER JOIN (CityArrival INNER JOIN (Airlines INNER JOIN ([Flight#] INNER JOIN ([FF#] INNER JOIN (DateTravel INNER JOIN (Daysofweek INNER JOIN ([Etkt#] INNER JOIN ([Conf#] INNER JOIN (Tripdate INNER JOIN Tripname ON Tripdate.ID = Tripname.ID) ON [Conf#].ID = Tripname.ID) ON [Etkt#].ID = Tripname.ID) ON Daysofweek.ID = Tripname.ID) ON DateTravel.ID = Tripname.ID) ON [FF#].ID = Tripname.ID) ON [Flight#].ID = Tripname.ID) ON Airlines.ID = Tripname.ID) ON (CityArrival.ID = Airlines.ID) AND (CityArrival.ID = Airlines.ID)) ON TimeDeparture.ID = Airlines.ID) ON TimeArrival.ID = Airlines.ID;
 

fkvice

New member
Local time
Today, 08:13
Joined
Jun 16, 2012
Messages
3
Also, because I am new and just took classes, I tried linking ID# in the tables. I just read that this is not a good idea.
 

Users who are viewing this thread

Top Bottom