[AccessD] Ambiguous Nmae in Query Expression

Not sure if this is relevent...but I searched google...and found another 
list that had this discussion.  Theirs turned out that the public function 
being used in the query was in multiple locations in the db and causing the 
Ambiguous error.  Do you have another macro/form/module named DaysInMonth2?

Hope it helps,

Mark A. Matte

>From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Ambiguous Nmae in Query Expression
>Date: Thu, 13 Apr 2006 11:13:27 -0500
>
>Shortened the query to the following. Changed the field name Date in the
>table ProdPattern to RecordDate. Still get the same error. Tried the
>function in the module and it worked fine. Thanks for the ideas.
>
>SELECT ProdPattern1.PID, DaysInMonth2([ProdPattern1].[RecordDate]) AS
>Expr1
>FROM [qry Pattern Days on Injection by Fluid] INNER JOIN ProdPattern1 ON
>([qry Pattern Days on Injection by Fluid].Date =
>ProdPattern1.RecordDate) AND ([qry Pattern Days on Injection by
>Fluid].PID = ProdPattern1.PID);
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Thursday, April 13, 2006 10:32 AM
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] Ambiguous Nmae in Query Expression
>
>Chester,
>
>I've seen all of the other ideas...how about just removing one field at
>a
>time from your select query until you find the offending field...then
>that
>might give some direction.
>
>Thanks,
>
>Mark A. Matte
>
>
> >From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: "Access Developers discussion and problem
> >solving"<accessd at databaseadvisors.com>
> >Subject: [AccessD] Ambiguous Nmae in Query Expression
> >Date: Thu, 13 Apr 2006 08:41:11 -0500
> >
> >I have a function in a module as follows:
> >
> >Function DaysInMonth2(D As Variant) As Variant
> >
> >
> >
> >When I try to use the function in a query I get the message Ambiguous
> >Name in Query Expression (DaysInMonth2([ProdPattern]![Date]) AS Expr1)
> >
> >This is the first time I have tried to use a user defined function in a
> >query. I need some help on how to do this. Thanks
> >
> >
> >
> >The SQL is a follows:
> >
> >SELECT ProdPattern.PID, ProdPattern.Date, ProdPattern.vm_wtri,
> >ProdPattern.vm_co2i, [qry Pattern Days on Injection by
> >Fluid].vm_dyswtri, [qry Pattern Days on Injection by Fluid].vm_dysco2i,
> >DaysInMonth2([ProdPattern]![Date]) AS Expr1
> >
> >FROM ProdPattern INNER JOIN [qry Pattern Days on Injection by Fluid] ON
> >(ProdPattern.PID = [qry Pattern Days on Injection by Fluid].PID) AND
> >(ProdPattern.Date = [qry Pattern Days on Injection by Fluid].Date)
> >
> >WHERE (((ProdPattern.PID)=[Pattern Name]));
> >
> >
> >
> >Chester Kaup
> >
> >Engineering Technician
> >
> >Kinder Morgan CO2 Company, LLP
> >
> >Office (432) 688-3797
> >
> >FAX (432) 688-3799
> >
> >
> >
> >
> >
> >No trees were killed in the sending of this message. However a large
> >number of electrons were terribly inconvenienced.
> >
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com