[AccessD] Ambiguous Nmae in Query Expression

Kaup, Chester Chester_Kaup at kindermorgan.com
Thu Apr 13 09:58:04 CDT 2006


No [qry Pattern Days on Injection by Fluid]  is not based on the table
ProdPattern. I might try something with the date thing anyway.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Thursday, April 13, 2006 9:48 AM
To: Access Developers discussion and problem solving
Subject: Re: [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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list