linking Queries

  • Thread starter Thread starter Steven Phillips via AccessMonster.com
  • Start date Start date
S

Steven Phillips via AccessMonster.com

I have several queries which are linked to the same table. There are
several different columns in my table for machines from different dept's
and which perform different functions. The quaries seperate these machines
by area and function. My problem- I cant run a report for completed daily
or month to date because the querie wizard will not link the seperate
queries.
Thanks
 
I have several queries which are linked to the same table. There are
several different columns in my table for machines from different dept's
and which perform different functions. The quaries seperate these machines
by area and function. My problem- I cant run a report for completed daily
or month to date because the querie wizard will not link the seperate
queries.
Thanks
Click to expand...

Please post the SQL view of at least a couple of the queries, and a
description of your table structure. I fear that your table may not be
properly normalized; if you have departments or functions as column
names, you may not be ABLE to join them.

John W. Vinson[MVP]
 
John,
Here are three SQL views from those queries.

SELECT [SUB Total Periphery Grind Kyon].Date, Sum([SUB Total Periphery
Grind Kyon].SumOfPieces) AS [total ground]
FROM [SUB Total Periphery Grind Kyon]
GROUP BY [SUB Total Periphery Grind Kyon].Date
HAVING ((([SUB Total Periphery Grind Kyon].Date)=Date()-1));

SELECT Sum([SUB Total Periphery Grind Kyon].[SumOfPieces]) AS
SumOfSumOfPieces
FROM [SUB Total Periphery Grind Kyon];

SELECT [INPUT Daily Grinding Data].[Date], [INPUT Daily Grinding Data].[ADV
MAT MACHINE], Sum([INPUT Daily Grinding Data].[Pieces]) AS SumOfPieces
FROM [INPUT Daily Grinding Data]
GROUP BY [INPUT Daily Grinding Data].[Date], [INPUT Daily Grinding Data].
[ADV MAT MACHINE]
HAVING ((([INPUT Daily Grinding Data].[ADV MAT MACHINE])="1506-225 CNC
EWAG"));

Table structure-
Columns are;

Date Kyon Machine Adv Mat Machine Empl ID# hrly goal Pieces .....>

The Kyon machine and adv mat machine are combo boxes.

Thanks for the help. I thought things were going pretty good and I'm almost
finished. I'm hoping all my efforts aren't in vain.
Steve
 
Back
Top