Re: [MS_AccessPros] Getting Max Effdt question

 

Hi Jim,

I think this might work exactly the same but you need to test by first running this as a select query.

SELECT MinMidMax.Effdt, MinMidMax.Jobcode, MinMidMax.Descr,

 MinMidMax.Grade, MinMidMax.[Sal Range Min Rate],

 MinMidMax.[Sal Range Mid Rate], MinMidMax.[Sal Range Max Rate],

 MinMidMax.[Empl Class] 

INTO MaxEffDtMinMidMaxAllASU

FROM MinMidMax 

WHERE EFFDAT = 

(SELECT Max(MMM.Effdt) FROM MinMidMax MMM WHERE MMM.JobCode = MinMidMax.JobCode);

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, November 1, 2018 1:20 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Getting Max Effdt question

 

Hello all,

I am working on a process that has several queries. There are two queries to get a final data set.

the first query is embedded into the other. . Is there a away to only use one query to get the max date?

Thank You

Jim Wagner

qry_MaxEffDtMinMidMax

SELECT MinMidMax.Jobcode, Max(MinMidMax.Effdt) AS MaxOfEffdt
FROM MinMidMax
GROUP BY MinMidMax.Jobcode;

qry_GetMaxEffDtMINMIDMAX

SELECT MinMidMax.Effdt, MinMidMax.Jobcode, MinMidMax.Descr, MinMidMax.Grade, MinMidMax.[Sal Range Min Rate], MinMidMax.[Sal Range Mid Rate], MinMidMax.[Sal Range Max Rate], MinMidMax.[Empl Class] INTO MaxEffDtMinMidMaxAllASU
FROM qry_MaxEffDtMinMidMax INNER JOIN MinMidMax ON (qry_MaxEffDtMinMidMax.MaxOfEffdt = MinMidMax.Effdt) AND (qry_MaxEffDtMinMidMax.Jobcode = MinMidMax.Jobcode);

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___