How can I get a data and auto-number field to link?

[kmt1984]

The database is locked down and really the only thing we can do is query the
information.

Basically I have an account number in an auto-number field in one table, and
an account number in a text field in the other table. They are the only two
common fields.

Any help is greatly appreciated!!!

 

[John W. Vinson]

The database is locked down and really the only thing we can do is query the
information.

Basically I have an account number in an auto-number field in one table, and
an account number in a text field in the other table. They are the only two
common fields.

Any help is greatly appreciated!!!

Whoever designed this database should be ashamed of themselves.

Assuming the text field contains just numeric digits (i.e. the autonumber 3124
matches the text field "3124" or "00003124"), you can join the Autonumber
field to Val([textfield]).