John W. Colby
jcolby at colbyconsulting.com
Wed Feb 19 07:30:01 CST 2003
Are the data types different for two fields that are joined? John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Michael Maddison Sent: Wednesday, February 19, 2003 1:28 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Puzzling error msg? <Invalid precision for decimal data type.> Drew, It is really strange because I remove all the calced fields and just leave a string field in the select statement, try to create a recordset and it fails with the same error!!! This leaves me thinking that it has to be a problem in the joins somewhere (or Access hates me). I've checked the top level but I guess I'll have to burrow into the base queries, maybe run them individually and see what I find. Michael M So you don't have the problem with Access right? That kind of sucks, because with Access, you could put a user defined function into the query, and have it let you 'walk' through the records...so you could trace where it has a problem. Drew _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2416 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030219/3be6c08d/attachment-0002.bin>