[AccessD] Query Linking Unlike Fields

Could you run an intermediate query to convert the data type?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
- Beach Access Software
Sent: Wednesday, May 03, 2006 8:51 AM
To: Access Developers discussion and problem solving
Subject: [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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com