[AccessD] Query Linking Unlike Fields

That's elegant.  I don't mind losing the design view.  It's a simple 
enough query that you can still understand it in SQL view.

I hope the table gets large enough to see a performance hit. :)

Rocky


rusty.hammond at cpiqpc.com wrote:
> I've pulled this off (in Access 97) by going to the SQL view of the query
> and converting one of the fields to the matching datatype,
>
> SELECT tblMyTable.AffiliateID, tblMyTable.Desc, tblPayPal.Desc
> FROM tblMyTable INNER JOIN tblPayPal ON tblMyTable.AffiliateID =
> clng(tblPayPal.AffiliateID);
>
> The drawback to this is while the clng is in the SQL of the query, the join
> can't be represented in design view.  I would imagine with large tables you
> would see a performance hit but I haven't done any testing.
>
> HTH
> Rusty
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> 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