greatest value
in [Queries]
|
Prev: IFF statement Repost
Next: SQL vs. VBA
From: Delsa_SCCD on 25 Jan 2010 13:47 How would the critera be wrote to get a greatest value? (Not greater than, but just the greatest - I don't want to see any other entries)
From: Jeff Boyce on 25 Jan 2010 14:07 Change your query to a Totals query. Use "Maximum". Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Delsa_SCCD" <u57761(a)uwe> wrote in message news:a2a691ba88e38(a)uwe... > How would the critera be wrote to get a greatest value? (Not greater than, > but just the greatest - I don't want to see any other entries) >
From: Lynn Trapp on 25 Jan 2010 14:28 SELECT Field1, Field2, Field3 FROM YourTable WHERE Field1 = (SELECT Max Field1 FROM YourTable); Since you didn't post anything about your table, I'm just using generic names here. -- Lynn Trapp MCP, MOS, MCAS "Delsa_SCCD" wrote: > How would the critera be wrote to get a greatest value? (Not greater than, > but just the greatest - I don't want to see any other entries) > > . >
From: Duane Hookom on 25 Jan 2010 14:50 Also, SELECT TOP 1 tblNoName.* FROM tblNoName ORDER BY tblNoName.fldNoName DESC; -- Duane Hookom Microsoft Access MVP "Delsa_SCCD" wrote: > How would the critera be wrote to get a greatest value? (Not greater than, > but just the greatest - I don't want to see any other entries) > > . >
From: Delsa_SCCD on 25 Jan 2010 14:50
well, that doesn't seem to be enough info to help me.... let me fill you in a bit more. Access 2003, the current query looks like this: Field #1: Well ID, Field #2: date, Field #3: Time. There are a handful of different times recorded per day, per well id..... I need the query to show me just the latest time per day, per well id. (there is also a number of dates entered per well id) Jeff Boyce wrote: >Change your query to a Totals query. > >Use "Maximum". > >Regards > >Jeff Boyce >Microsoft Access MVP > >> How would the critera be wrote to get a greatest value? (Not greater than, >> but just the greatest - I don't want to see any other entries) |