[AccessD] Ambiguous Nmae in Query Expression

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.