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
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) |
Tidak ada komentar:
Posting Komentar