Rabu, 14 Maret 2018

RE: [MS_AccessPros] Re: Crosstab query help needed

 

FYI to all...

When you want to show us data the best thing to do is to put it in a comma-delimited format. That way we can import it into an Access table and play with it. Trying to format any other way will only delay our help as we will have to re-format no matter how pretty it looks.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
That'll do IT http://thatlldoit.com

My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of tcellr777
Sent: Wednesday, March 14, 2018 5:32 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Crosstab query help needed

 

 

Formatting was lost, so retrying:

 

ORDER_NO          TASK_NAME             CREATED_DATE      COMPLETE_DATE              DIFFERENCE

 

 2017-25420     Pricing - Banana              04/05/2017               06/12/2017                            68 

 2017-25420     Pricing  - Banana             04/07/2017               06/12/2017                            66

 

 2017-25420     Pricing - Carrots              07/01/2017               07/12/2017                            11 

 2017-25420    Pricing  - Carrots              07/11/2017               07/12/2017                            01

 

 

I haven't done a crosstab query for a long while, but I think that is what I kinda need.  The query needs to show all of the above columns, and the closest date difference for each of the above groups.  The order numbers do change.  Do I have to concatenate the first three columns, in order to pick the best difference?  If possible, I think a simple SQL solution would work, but I can't think of any right now.

 

Idea result would be:

2017-25420     Pricing  - Banana             04/07/2017               06/12/2017                            66

2017-25420     Pricing  - Carrots              07/11/2017               07/12/2017                            01

 

 

Thanks for any help,

Mark B.

 

 

 

__._,_.___

Posted by: "Bill Mosca" <wrmosca@comcast.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

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.


.

__,_._,___

Tidak ada komentar:

Posting Komentar