Im betting that most of you will find this to be an easy question regarding COUNT

Hey all -

Im pretty certain that this is a lot easier then i am making it out to be...

I've got a query referencing two tables. As you can see in the picture attached, the query is pulling the number of associates working on a platform and Production from another table. The problem im having is that I need it to give me a total # of units produced with how many associates. So say for example with 360 wireless contoller repair, i had 15 techs working on this platform so i want to see all the prior info and 677 under production, vs the individual breakdown.

Thanks in advance,
Daniel

Attached Images

2in1.jpg (65.2 KB, 212 views)

Jul 27 '14 #1

Subscribe Post Reply

783

danielfinzel

i've figured this out.. Thanks anyways guys sorry to waste your time

Jul 27 '14 #2

zmbd

5,501

Expert Mod 4TB

Daniel,
Would mind posting your solution? You could potentially save someone from being beaten by a monkey... ok, just from loosing their sanity :)

Jul 28 '14 #3

Similar topics

383

Why Windows Lost The Battle for the Desktop

by: John Bailo | last post by:

The war of the OSes was won a long time ago. Unix has always been, and will continue to be, the Server OS in the form of Linux. Microsoft struggled mightily to win that battle -- creating a...

.NET Framework

Compilation error - Most likely embarassingly easy, but I can't find what's wrong.

by: Sune | last post by:

Hi, previously I used Eclipse CDT for compiling my files just to get started with C and leave C++ behind. Now it's time to get a little more serious so I've moved my files to a new workplace and...

C / C++

How to find selected row count in datagrid view control

by: Tim Kelley | last post by:

I found the following code on the MS website: and tried it, but it did not work: Int32 selectedRowCount = dataGridView1.Rows.GetRowCount(DataGridViewElementStates.Selected); The error says:...

C# / C Sharp

Non-local reference count pointer

by: ank | last post by:

Hi, all. I've come to think of the idea of automatic initialization/deinitialization of non-local reference count pointer. I've made an assumption that the user of the pointer only read...

C / C++

Question regarding fgets and new lines

by: mellyshum123 | last post by:

I need to read in a comma separated file, and for this I was going to use fgets. I was reading about it at http://www.cplusplus.com/ref/ and I noticed that the document said: "Reads characters...

C / C++

The most comprehensive furniture information .You will find the mostsuitable for you!

by: shoubiao189 | last post by:

The most comprehensive furniture information .You will find the most suitable for you! click:::http://www.popotj.cn/

C / C++

find details regarding programming languages

by: gokul | last post by:

You can find all related details regarding programming languages right from C/C++, Java, .net and many more. Find details of the jobs available in C/C++ programming language platforms ...

C# / C Sharp

How to find unique chars count of a string in javascript?

by: suchetapatra | last post by:

Unique characters: Eg: If 'unique' is a keyword, the unique characters count should be = 4

Javascript

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice