[AccessD] Query Linking Unlike Fields

I suppose...do a make table query with the payment fields I want and the 
affiliate number in a long integer field?  Then run a second select 
query to get the info? Makes it a two-step process but it'll work.  I 
could link them to a button on a form that would run the make-table and 
then run a report with the second query as the record source.

Rocky


Kaup, Chester wrote:
> 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