troubleshooting Question

Access Query 2010 grouping

Avatar of Genius123
Genius123Flag for United States of America asked on
Microsoft Access
14 Comments1 Solution92 ViewsLast Modified:
Hello,

I have a query that pulls dates for different work cells.  Here's the code:

SELECT dbo_projects.job_number, dbo_projects.jobid, dbo_projects_schedule.series, Format(DateAdd("s",[act_start_cut],#1/1/1970#),"mm/dd/yy") AS [CUTTING START], Format(DateAdd("s",[act_end_cut],#1/1/1970#),"mm/dd/yy") AS [CUTTING END], Format(DateAdd("s",[act_start_mach],#1/1/1970#),"mm/dd/yy") AS [MACHINING START], Format(DateAdd("s",[act_end_mach],#1/1/1970#),"mm/dd/yy") AS [MACHINING END], Format(DateAdd("s",[act_start_weld],#1/1/1970#),"mm/dd/yy") AS [WELDING START], Format(DateAdd("s",[act_end_weld],#1/1/1970#),"mm/dd/yy") AS [WELDING END], Format(DateAdd("s",[act_start_prep],#1/1/1970#),"mm/dd/yy") AS [FAB PREP START], Format(DateAdd("s",[act_end_prep],#1/1/1970#),"mm/dd/yy") AS [FAB PREP END], Format(DateAdd("s",[act_start_coat],#1/1/1970#),"mm/dd/yy") AS [COATING START], Format(DateAdd("s",[act_end_coat],#1/1/1970#),"mm/dd/yy") AS [COATING END], Format(DateAdd("s",[act_start_assy],#1/1/1970#),"mm/dd/yy") AS [ASSEMBLY START], Format(DateAdd("s",[act_end_assy],#1/1/1970#),"mm/dd/yy") AS [ASSEMBLY END]
FROM dbo_projects LEFT JOIN dbo_projects_schedule ON dbo_projects.jobid = dbo_projects_schedule.jobid
GROUP BY dbo_projects.job_number, dbo_projects.jobid, dbo_projects_schedule.series, Format(DateAdd("s",[act_start_cut],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_end_cut],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_start_mach],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_end_mach],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_start_weld],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_end_weld],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_start_prep],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_end_prep],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_start_coat],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_end_coat],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_start_assy],#1/1/1970#),"mm/dd/yy"), Format(DateAdd("s",[act_end_assy],#1/1/1970#),"mm/dd/yy")
HAVING (((dbo_projects.job_number)="12203216") AND ((dbo_projects_schedule.series)="A2"));


and here's the result:

result 1
Notice the highlighted fields.  I want group it somehow to get one record like this:

result 2
Thanks for your help,
Joel
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros