Bill,
My boss has insisted that there are multiple examples of when this has not worked correctly. We have always created a query with max date and then added that query to another query and linked on the appropriate fields and found the max sequence. that is why I am confused.
Jim Wagner
________________________________
________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, September 21, 2011 9:08 AM
Subject: [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
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar