Converting Text to Integer

[kstump]

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.

 

[Ukraine82]

Take a look at the site below.

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

hth,
Michael