Re: [MS_AccessPros] Crosstab query help needed

 

Hi Mark,

I'm not seeing your data or records or fields in your email. I think you only need to group by most fields and then specify the minimum on the difference field.

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of tcellr777 <no_reply@yahoogroups.com>
Sent: Wednesday, March 14, 2018 5:07 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Crosstab query help needed

 

I am trying to get the minimum difference row, based on COMPLETED_DATE, difference from CREATED_DATE, from another query.

ORDER_NO TASK_NAME CREATED_DATE COMPLETE_DATE DIFFERENCE 2017-25420 Pricing approved - Banana 04/05/2017 06/12/2017 68 2017-25420 Pricing approved - Banana 04/07/2017 06/12/2017 66

For this, I need the last row because the lowest difference is 66.

Thanks much,
Mark B.

__._,_.___

---

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

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___