query
- From: x taol <tomi3440@xxxxxxxxx>
- Date: Wed, 31 May 2006 04:45:54 GMT
i want to a query.
SELECT MAX(fNum) FROM tTable WHERE fDate IN (SELECT MAX(fDate) FROM
tTable WHERE fDate IN (SELECT fDate
FROM tTable WHERE fDate IN (SELECT fDate FROM tTable WHERE
(fRegion="Califo") AND (fProduct="G274") AND (fColor="Brown") AND
(fDate<=#5/13/2006#))))
unfortunately, the upper query is not working in my hope.
i want to following query.
there are records in (fRegion="Califo") AND (fProduct="G274") AND
(fColor="Brown") AND (fDate<=#5/13/2006#).
there are records in maximum fDate in the records.
and then last
there is record of a maximum fNum in the records.
*** Sent via Developersdex http://www.developersdex.com ***
.
- Prev by Date: Re: Web Service: Which Way In?
- Next by Date: Re: How will Access Survive
- Previous by thread: Web Service: Which Way In?
- Next by thread: Code to add and verify existing data
- Index(es):
Relevant Pages
|
