Query returning same field value from two diffenrent tables

N

NielsE

In the following query that is the source for a list box:
SELECT tblPROJECTS.Projectsymbol, tblPROJECTS.Title, tblPROJECTS.StatusDate,
tblPROJECTS.Budget, tblPROJECTS.Projectdocument, tblPROJECTS.Status,
tblPROJECTS.Region, tblProjectSubject.SubjectName, tblPROJECTS.ProjectID, *
FROM tblPROJECTS INNER JOIN tblProjectSubject ON tblPROJECTS.ProjectID =
tblProjectSubject.ProjectID;
I get the ProjectID returned from both tblProjects and tblProjectSubject,
which gives me an error message when i open the form.
Can somebody please tell why and what i should change to get the query right.
Thanks.
Niels
 
O

OfficeDev18 via AccessMonster.com

I think you need to remove the '*' at the end of the SELECT clause. If you
really want all fields from tblProjects, get rid of all the detail fields in
the SQL statement and just keep the '*' and the one field from
tblProjectdocument.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top