Simple Queries

[Guest]

I have two simple tables "Employees" and "Reports" all include Text fields.
I am trying to create a query to combine the two. I keep getting an error
that Access cant represent the join of
([Employees].[EmployeeID]=[Reports].[EmployeeID]) AND
([Employees].[FirstName]=[Reports].[EmployeeID]).

do i have a relationship problem or do i need to create a third table that
shows the relationship of Report authors to their information (which is in
the Employee table)

 

[Guest]

Looks like you are trying to compare a name with an ID
Do you have both tables in your FROM clause?
Do you have columns with those names in the tables?

-Dorian

 

[Guest]

I was able to view the query at least now;
however now i have an issue with having more than one employee number in the
EmployeeID column (more than one author on a Report) and those are not
showing up do you have any suggestions as to how i can view the reports that
have more than one employee associated with them?
Thanks for your response

Looks like you are trying to compare a name with an ID
Do you have both tables in your FROM clause?
Do you have columns with those names in the tables?

-Dorian

I have two simple tables "Employees" and "Reports" all include Text fields.
I am trying to create a query to combine the two. I keep getting an error
that Access cant represent the join of
([Employees].[EmployeeID]=[Reports].[EmployeeID]) AND
([Employees].[FirstName]=[Reports].[EmployeeID]).

do i have a relationship problem or do i need to create a third table that
shows the relationship of Report authors to their information (which is in
the Employee table)