populate table through query or something???

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Perhaps you can use the FIRST function to get one of the ticketnumbers
associated with the data in the group. Alternative is to use Min and Max on
the ticket number to get the range of ticket numbers associated with the
group, or just Max or just Min to get one of the ticket numbers.
 
Back
Top