Re: [MS_AccessPros] Specific Grouping quesion for a report

 

Hi Jim,

Can you describe your table structure and relationships? I assume this is a basic org chart/bill of materials type structure.

I think you can use Nz() with LEFT JOINs but I'm not sure.

Regards,

Duane Hookom

MN

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, September 5, 2017 12:14 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Specific Grouping quesion for a report

 

Hello all,

I am trying to create a report that shows the Reports to for Accruals of vac, sick. I have a table that has all of the Reports to from the following

Dept Head

Asc/Ast Dir

Supervisor

Ast Sup/Lead

The problem is that some employees only have a Dept Head and one only has a supervisor. the users would like to have the lowest person on the report to be the grouping header.

Currently I have the following sql statement

SELECT SupervisorTable.[Person Nm], SupervisorTable.[Person Id], AccrualsForReport.sick, AccrualsForReport.comp, AccrualsForReport.vac, AccrualsForReport.[Accrual Proc Dt], AccrualsForReport.[Last Name], AccrualsForReport.[First Name], SupervisorTable.[Ast Sup/Lead], SupervisorTable.Supervisor, SupervisorTable.[Asc/Ast Dir], SupervisorTable.[Dept Head]
FROM SupervisorTable INNER JOIN AccrualsForReport ON SupervisorTable.[Person Id] = AccrualsForReport.Emplid
WHERE (((SupervisorTable.[Person Id]) Not Like "1208509350") AND ((SupervisorTable.[Dept Head]) Is Not Null));

I do not see a clear way of getting the lowest Reports to with so many different variables.

Thank You for any advice

Jim Wagner

__._,_.___

---

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

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___