[AccessD] Trying to avoid coding

[Rocky Smolin]

Excellent. I'll try it!

Thx

Rocky
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David McAfee
Sent: Monday, June 01, 2015 1:29 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Trying to avoid coding

Replace SomeDate with your Date, SomeTable with your table (or query) and
1=1 with your cirteria

MaxDate:
Expr1: DMax("SomeDate","tblSomeTable","1=1")

2nd highest Date:
Expr2:
DMax("SomeDate","tblSomeTable","[SomeDate]<DMax('SomeDate','tblSomeTable','1
=1')")

On Mon, Jun 1, 2015 at 1:08 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> Dear List:
>
> I'm exporting stuff to a spreadsheet and using a query and that's 
> working just fine.  The user wanted the last date in one of the tables 
> so a summation query, grouping on all the fields except the date field 
> and using MAX on the field with the dates worked out nice.
>
> Now he wants both the last date and the previous date (users (sigh) 
> gotta love 'em) - IOW the last two dates.  I can do this with code and 
> push the values into a spreadsheet through automation, but that 
> TransferSpreadsheet is just soooooo easy and I'm getting lazier in my old
age.
>
> So is there a way to pull the last two values from a field in a table 
> when you sort on that field with a query, getting the last value in 
> one of the columns and the second to last in another?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> <http://www.e-z-mrp.com/>
> Skype: rocky.smolin
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com