looking up values in a query

[echorley]

I have two tables that I do not believe I can join, but I need data from one of the tables during a query. Here is goes:

In one table I have offensive football statistics, in another, I have player information.

In the Offense Statistics tables, players are identified by number only.

In the queries I run to compile statistics, I need to be able to somehow use the player number from the Offense Statitistics table to get the name of the player from the Player Information table.

I have tried various joins between the two tables (with the player number from the Offense Statistics and the player number from Player Information) with no luck (keep getting a mismatch error).

I know I can code my way out of this problem, but hoping for a shortcut. Thanks!

 

[echorley]

Does anyone else experiece this?

As soon as you post to the forum, the solution (or error in this case) appears out of thin air! My players numbers were numbers in one form and text in another. Grrr!!