papparuff at comcast.net
papparuff at comcast.net
Wed May 3 09:10:39 CDT 2006
create a query for your affiliate ID that is an integer and convert it to text in the query. MyAffiliateID: CStr([affiliate ID]) Then you can use this query to link to the PayPal affiliate ID. papparuff -- John V. Ruff – The Eternal Optimist :-) “Commit to the Lord whatever you do, and your plans will succeed.” Proverbs 16:3 -------------- Original message -------------- From: Rocky Smolin - Beach Access Software <bchacc at san.rr.com> > 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