Advertisement

03.12.2008 at 11:45AM PDT, ID: 23236247
[x]
Attachment Details

Please modify the query to see result in the single row

Asked by rfedorov in SQL Query Syntax, Databases Miscellaneous, Microsoft Access Database

Tags: Micosoft, Office access, 2003, Office access query

Hi,*!!!
SELECT
CCZ_CCZ450_INVOICE.INVOICE_ID,
CCZ_CCZ450_INVOICE.INVOICE_NO,
Max(CCZ_CCZ050_STATUS_HIST.STATUS_DT) AS STATUS_DT, CCZ_CCZ050_STATUS_HIST.STATUS_CD_ID
FROM
CCZ_CCZ050_STATUS_HIST INNER JOIN ((CCZ_CCZ450_INVOICE INNER JOIN CCZ_CCZ021_CODES ON CCZ_CCZ450_INVOICE.STATUS_CD_ID = CCZ_CCZ021_CODES.CODE_ID) INNER JOIN CCZ_CCZ500_PROGRAM ON CCZ_CCZ450_INVOICE.PGM_ID = CCZ_CCZ500_PROGRAM.PGM_ID) ON CCZ_CCZ050_STATUS_HIST.LEVEL_KEY_ID = CCZ_CCZ450_INVOICE.INVOICE_ID

WHERE
(((CCZ_CCZ450_INVOICE.INVOICE_ID)=8081921) AND ((CCZ_CCZ050_STATUS_HIST.STATUS_CD_ID)=21 Or (CCZ_CCZ050_STATUS_HIST.STATUS_CD_ID)=19) AND ((CCZ_CCZ050_STATUS_HIST.LEVEL_ID)=13))

GROUP BY

CCZ_CCZ450_INVOICE.INVOICE_ID,
CCZ_CCZ450_INVOICE.INVOICE_NO,
CCZ_CCZ050_STATUS_HIST.STATUS_CD_ID;


works fine and return:

INVOICE_ID      INVOICE_NO      STATUS_DT      STATUS_CD_ID
1111111      customer                           2/15/2008 1:31:50 PM      19
1111111      customer                          2/20/2008 10:15:09 AM      21
--------->I want to see:
INVOICE_ID      INVOICE_NO      STATUS_DT_1      STATUS_DT_2
1111111      customer                           2/15/2008 1:31:50 PM      2/20/2008 10:15:09 AM
please help!!!Start Free Trial
[+][-]03.12.2008 at 03:06PM PDT, ID: 21111292

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 03:10PM PDT, ID: 21111324

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 03:51PM PDT, ID: 21111636

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 04:03PM PDT, ID: 21111709

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 05:51PM PDT, ID: 21112335

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 06:58PM PDT, ID: 21112735

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 07:58PM PDT, ID: 21112968

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 09:22PM PDT, ID: 21113325

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.13.2008 at 02:49AM PDT, ID: 21114496

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.13.2008 at 04:02AM PDT, ID: 21114887

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]03.13.2008 at 05:46AM PDT, ID: 21115575

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.13.2008 at 08:42AM PDT, ID: 21117350

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.13.2008 at 12:01PM PDT, ID: 21119573

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.13.2008 at 12:06PM PDT, ID: 21119628

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.13.2008 at 12:22PM PDT, ID: 21119822

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.13.2008 at 12:26PM PDT, ID: 21119873

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Query Syntax, Databases Miscellaneous, Microsoft Access Database
Tags: Micosoft, Office access, 2003, Office access query
Sign Up Now!
Solution Provided By: ramrom
Participating Experts: 4
Solution Grade: B
 
 
[+][-]03.13.2008 at 12:29PM PDT, ID: 21119910

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628