How do I display the most recent of three dates in an Access quer.
in [Queries]
|
Prev: How do I show all characters before the letter A in a Query?
Next: Autofill field based on a table of allowable values
From: Claudia1220 on 25 Mar 2010 16:07 How do I display the most recent (or latter) of three dates in an Access query?
From: Jerry Whittle on 25 Mar 2010 16:12 I'm assuming that the date field is truely a date/time datatype and not a text field with something that looks like a date. 1. Create a query and sort on that field in descending order. Run it to make sure it looks correct. 2. Open the query in SQL view. Change where it says SELECT to SELECT TOP 3 One caution: If there is a tie for 3rd place, Access will show all the tied records. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Claudia1220" wrote: > How do I display the most recent (or latter) of three dates in an Access query?
From: Jeff Boyce on 25 Mar 2010 17:25
"How" depends on "what", as in "what does your data/table structure look like"? 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. "Claudia1220" <Claudia1220(a)discussions.microsoft.com> wrote in message news:B1A64246-6EFA-426F-B408-D12E4A1246BF(a)microsoft.com... > How do I display the most recent (or latter) of three dates in an Access > query? |