Group with criteria problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that returns what I need. I want to improve this query by
sorting and grouping more.

How would I include - if lot numbers are the same and the variety is the
same and the receive date is the same go ahead and group/add together

Any ideas would be helpful.

Thanks
 
Show us the SQL for your query. Open the query in SQL view and copy and past
it here. Information on primary keys and relationships would be a nice touch
too.
 
SELECT qryMergedData.[Run Order], qryMergedData.PostDate,
qryMergedData.RecvDate, qryMergedData.LotNum, qryMergedData.PoolNum,
qryMergedData.Variety, qryMergedData.TicketNum, qryMergedData.Bins,
qryMergedData.MaxFirm, qryMergedData.MinFirm, qryMergedData.AvgFirm,
qryMergedData.StdFirm, qryMergedData.P080, qryMergedData.P085,
qryMergedData.P090, qryMergedData.P095, Sum([P080]+[P085]+[P090]+[P095]) AS
[<P095], qryMergedData.P100, qryMergedData.P105, qryMergedData.P110,
qryMergedData.P115, qryMergedData.P120, qryMergedData.P130,
qryMergedData.CullP, qryMergedData.BrineP, qryMergedData.RDate,
qryMergedData.Packed, qryMergedData.Comments
FROM qryMergedData
GROUP BY qryMergedData.[Run Order], qryMergedData.PostDate,
qryMergedData.RecvDate, qryMergedData.LotNum, qryMergedData.PoolNum,
qryMergedData.Variety, qryMergedData.TicketNum, qryMergedData.Bins,
qryMergedData.MaxFirm, qryMergedData.MinFirm, qryMergedData.AvgFirm,
qryMergedData.StdFirm, qryMergedData.P080, qryMergedData.P085,
qryMergedData.P090, qryMergedData.P095, qryMergedData.P100,
qryMergedData.P105, qryMergedData.P110, qryMergedData.P115,
qryMergedData.P120, qryMergedData.P130, qryMergedData.CullP,
qryMergedData.BrineP, qryMergedData.RDate, qryMergedData.Packed,
qryMergedData.Comments
HAVING (((qryMergedData.Packed)=False))
ORDER BY qryMergedData.[Run Order], qryMergedData.TicketNum;
 
Back
Top