[AccessD] How to query to get result?

How about a couple IIF statements?

 

SELECT IIf([pmo]>[pmo1],IIf([pmo]>[pmo2],[pmo],[pmo2]),IIf([pmo1]>[pmo2],[pmo1],[pmo2])) AS DT, tblTest.*, IIf([pmo]>[pmo1],IIf([pmo]>[pmo2],[t],[t2]),IIf([pmo1]>[pmo2],[t1],[t2])) AS Type
FROM tblTest;


...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