[AccessD] Query Linking Unlike Fields

Dear List:

The affiliate ID in our affiliate program is a long integer - as it 
should be.  However, the affiliate ID is recorded from the PayPal 
transaction in a text field.  So When I try to link them in a query to 
show affiliate sales by affiliate name, of course, I get a data type 
mismatch.  Is there a way around this short of altering the tables?

MTIA,

Rocky

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com