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
>
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar