Record Selection by Current As of Date
 

For Unit 100 from Property 0081, I need to find ONLY the most current As of
Date and its associated Sq Footage but my query returns ALL As of Dates and
associated Sq Footage. How can I return only the most current? Thanks.

Property Unit SF Type As of Date Sq Ft

0081 100 Rentable 12/1/1996 92246
0081 100 Rentable 12/1/2001 58387
0081 100 Rentable 5/15/2008 40345

Here is my SQL query:

SELECT
"UFPROP" AS "Property",
"UFUNIT" AS "Unit",
"UFSFTYP" AS "SF type",
"UFDATE" AS "As-of Date",
"UFSF" AS "Square footage"
FROM
"PROPERTY_PMP_RECORD_19"
Where
((UFSFTYP = 'Rentable') AND (UFUNIT = '100'))

Kalli

Record Selection by Current As of Date
 

MaxRe cords is not part of the SQL, it is either an option on the query
table or recordset

For record set
rstTemp.MaxRecords = 10
rstTemp.Open "SELECT Title, Price FROM Titles " & _
"ORDER BY Price DESC", strCnn, , , adCmdText
For Query table only using ODBC

With ActiveSheet.QueryTables.Add(Connection:=Array(Arra y( _
"ODBC;DSN=MS Access
Database;DBQ=C:\temp\submission.mdb;MaxRecords=1;D efaultDir=C:\temp;DriverId=25;FIL=MS
Access;MaxBufferSize=5;PageTimeout=5" _
), Array(";")), Destination:=Range("D4"))


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=151895

Microsoft Office Help

Record Selection by Current As of Date
 

If your dates are true dates (numeric) why not try =MAX(RangeOfDate) to get the
highest number = Latest date (most current?).

"KalliKay" wrote:

For Unit 100 from Property 0081, I need to find ONLY the most current As of
Date and its associated Sq Footage but my query returns ALL As of Dates and
associated Sq Footage. How can I return only the most current? Thanks.

Property Unit SF Type As of Date Sq Ft

0081 100 Rentable 12/1/1996 92246
0081 100 Rentable 12/1/2001 58387
0081 100 Rentable 5/15/2008 40345

Here is my SQL query:

SELECT
"UFPROP" AS "Property",
"UFUNIT" AS "Unit",
"UFSFTYP" AS "SF type",
"UFDATE" AS "As-of Date",
"UFSF" AS "Square footage"
FROM
"PROPERTY_PMP_RECORD_19"
Where
((UFSFTYP = 'Rentable') AND (UFUNIT = '100'))

Kalli