[AccessD] Ambiguous Nmae in Query Expression

On 13 Apr 2006 at 8:41, Kaup, Chester wrote:

>> 
> 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]));
> 

Just a WAG, but is [qry Pattern Days on Injection by Fluid]  based on 
ProdPattern and does it contain the field ProdPattern.Date?

If so, try giving the Date field in the query an alias like "PDate:[Date]"

-- 
Stuart