Using an Append query,you can append a Short Text field from one table to a Number field in another table.

Append Query

A type of query in databases that adds the results of a query to an existing table, rather than displaying them.

Short Text

A data type in databases designed to store alphanumeric characters, typically used for names, descriptions, or other short textual data.

Number Field

A field in a database designed to store numerical data.