I have two tables which are linked from a database I cannot change. Each table contains a field called Category. In what table it is defined as a text and the primary key. The other table defines the field as a number. I am trying to combine these in a query, but need to convert the text to an integer.

Take a look at the site below.

http://www.techonthenet.com/access/functions/misc/curr_to_words.htm

hth,
Michael

You would use the CInt() function. It will only work if your text field actually contains an integer.