[AccessD] How to query to get result?

My multiple query solution will return both ( or all three if appropriate) 
records if the dates are equal 

-- 
Stuart  


On 24 Mar 2009 at 13:37, Mark A Matte wrote:

> ...but something to think about...what if the dates are the same or equal?
> 
>  
> 
>  
> 
> Mark A. Matte
>  
> > From: Chester_Kaup at kindermorgan.com
> > To: accessd at databaseadvisors.com
> > Date: Tue, 24 Mar 2009 07:24:02 -0500
> > Subject: [AccessD] How to query to get result?
> > 
> > I have a table with a unique identifier column three date columns and a fluid type associated with each date. I need to extract from the table the most recent of the three dates for each record and its associated fluid type. I considered some kind of complex if statement but surely there is a better way. Below is a sample record.
> > 
> > PID Status ProdMonth Type ProdMonth1 Type1 ProdMonth2 Type2
> > 42415016970000 PA 4/1/1963 Oil 6/1/2003 CO2 7/1/2007 Water 
> > 
> > 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
> 
> _________________________________________________________________
> Hotmail® is up to 70% faster. Now good news travels really fast.
> http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_70faster_032009
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>