In Access2000, I have a two tables that I need for the query. Both have
JobNum as a field which is the primary key for each. They will both house
the same data. However, in one table the field is named JobNum and the
other is JobNumber. Is it ok to join these?

Yes.

--
HTH
Van T. Dinh
MVP (Access)



"Gary Nelson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In Access2000, I have a two tables that I need for the query. Both have
> JobNum as a field which is the primary key for each. They will both house
> the same data. However, in one table the field is named JobNum and the
> other is JobNumber. Is it ok to join these?
>
>