G
Guest
Here is my query
SELECT qryMergedData.RunOrder, qryMergedData.RecvDate, qryMergedData.LotNum,
qryMergedData.PoolNum, qryMergedData.Variety, Sum(qryMergedData.Bins) AS
Bins, Avg(qryMergedData.MaxFirm) AS MaxFirm, Avg(qryMergedData.MinFirm) AS
MinFirm, Avg(qryMergedData.AvgFirm) AS AvgFirm, Avg(qryMergedData.StdFirm) AS
StdFirm, Avg(qryMergedData.P080) AS P080, Avg(qryMergedData.P085) AS P085,
Avg(qryMergedData.P090) AS P090, Avg(qryMergedData.P095) AS P095,
Avg(qryMergedData.P100) AS P100, Avg(qryMergedData.P105) AS P105,
Avg(qryMergedData.P110) AS P110, Avg(qryMergedData.P115) AS P115,
Avg(qryMergedData.P120) AS P120, Avg(qryMergedData.P130) AS P130,
Avg(qryMergedData.CullP) AS CullP, Avg(qryMergedData.BrineP) AS BrineP,
qryMergedData.Packed
FROM qryMergedData
GROUP BY qryMergedData.RunOrder, qryMergedData.RecvDate,
qryMergedData.LotNum, qryMergedData.PoolNum, qryMergedData.Variety,
qryMergedData.Packed
HAVING (((qryMergedData.Packed)=False));
So basically what I have done is merged 2 queries together then grouped,
avg, sum etc in this query which gives me what I want. My problem is that
the 2 queries that I merged have a primary key of Ticket Number. This is the
only unique key. But when I group,sum,avg I cannot show this ticket number
because there are multiple ticket numbers to a lotnum and other factors. I
need to use this query but be able to use a column that I can enter random
numbers and then be able to sort in sequence. Any help would be appreciated.
Thanks
Zenia
SELECT qryMergedData.RunOrder, qryMergedData.RecvDate, qryMergedData.LotNum,
qryMergedData.PoolNum, qryMergedData.Variety, Sum(qryMergedData.Bins) AS
Bins, Avg(qryMergedData.MaxFirm) AS MaxFirm, Avg(qryMergedData.MinFirm) AS
MinFirm, Avg(qryMergedData.AvgFirm) AS AvgFirm, Avg(qryMergedData.StdFirm) AS
StdFirm, Avg(qryMergedData.P080) AS P080, Avg(qryMergedData.P085) AS P085,
Avg(qryMergedData.P090) AS P090, Avg(qryMergedData.P095) AS P095,
Avg(qryMergedData.P100) AS P100, Avg(qryMergedData.P105) AS P105,
Avg(qryMergedData.P110) AS P110, Avg(qryMergedData.P115) AS P115,
Avg(qryMergedData.P120) AS P120, Avg(qryMergedData.P130) AS P130,
Avg(qryMergedData.CullP) AS CullP, Avg(qryMergedData.BrineP) AS BrineP,
qryMergedData.Packed
FROM qryMergedData
GROUP BY qryMergedData.RunOrder, qryMergedData.RecvDate,
qryMergedData.LotNum, qryMergedData.PoolNum, qryMergedData.Variety,
qryMergedData.Packed
HAVING (((qryMergedData.Packed)=False));
So basically what I have done is merged 2 queries together then grouped,
avg, sum etc in this query which gives me what I want. My problem is that
the 2 queries that I merged have a primary key of Ticket Number. This is the
only unique key. But when I group,sum,avg I cannot show this ticket number
because there are multiple ticket numbers to a lotnum and other factors. I
need to use this query but be able to use a column that I can enter random
numbers and then be able to sort in sequence. Any help would be appreciated.
Thanks
Zenia