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

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

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