Group with criteria problem

E

esparzaone

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
 
J

Jerry Whittle

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.
 
E

esparzaone

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;
 
Top