[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