Rabu, 21 September 2011

[MS_AccessPros] Re: Find max date and sequence in the same query

 

Jim

Unless I'm missing needed info, there is no need to make 2 queries. You can get the Max of both fields in a single query.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, "luvmymelody" <luvmymelody@...> wrote:
>
> Hello,
>
> Is there a way of getting the max date and max sequence in the same query?
> I have two fields named
> EffdtNew
> Effseq
>
> I really do not want to create 2 queries to get the max date and then max sequence.
>
> Thank you
>
> Jim Wagner
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar