Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Wed May 3 09:29:35 CDT 2006
That does it!. Thanks Rocky papparuff at comcast.net wrote: > 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 >> -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com