[MS_AccessPros] Query Help

 

I have a Query which produces the following output:

 

Job Code / Description                  Group   License Code

87600 : SOC WKR-DISCHARGE     1              AUTO

87600 : SOC WKR-DISCHARGE     2              BLS

87600 : SOC WKR-DISCHARGE     2              BLS-I

87600 : SOC WKR-DISCHARGE     3              CMSW

87600 : SOC WKR-DISCHARGE     3              LMSW

87600 : SOC WKR-DISCHARGE     3              LSW

87600 : SOC WKR-DISCHARGE     3              SW1

87600 : SOC WKR-DISCHARGE     4              IMHP

87600 : SOC WKR-DISCHARGE     4              MHP

 

Here is the SQL code for it:

 

SELECT DISTINCT REQ_LIC_JOBCODE_TBL.[Job Code / Description], REQ_LIC_JOBCODE_TBL.GroupNum AS [Group], REQ_LIC_JOBCODE_TBL.[Lawson Lic Code] AS [License Code]

FROM REQ_LIC_JOBCODE_TBL

WHERE (((REQ_LIC_JOBCODE_TBL.[Job Code / Description])="87600 : SOC WKR-DISCHARGE"));

 

What I’d like it to do is produce the output in this fashion:

 

Job Code / Description                  Group   License Code

87600 : SOC WKR-DISCHARGE     1              AUTO

87600 : SOC WKR-DISCHARGE     2              BLS, BLS-I

87600 : SOC WKR-DISCHARGE     3              CMSW, LMSW, LSW, SW1

87600 : SOC WKR-DISCHARGE     4              IMHP, MHP

 

What would be the best approach to achieve my desired output?  Thanks in advance.

 

Bill Beshlian

 

---

The information contained in this communication, including attachments, is confidential and private and intended only for the use of the addressees. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you received this communication in error, please inform us of the erroneous delivery by return e-mail message from your computer. Additionally, although all attachments have been scanned at the source for viruses, the recipient should check any attachments for the presence of viruses before opening. Alegent Creighton Health accepts no liability for any damage caused by any virus transmitted by this e-mail. Thank you for your cooperation.

This electronic mail and any attached documents are intended solely for the named addressee(s) and contain confidential information. If you are not an addressee, or responsible for delivering this email to an addressee, you have received this email in error and are notified that reading, copying, or disclosing this email is prohibited. If you received this email in error, immediately reply to the sender and delete the message completely from your computer system.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (37)

Visit Your Group

• New Members 6

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___