1 2 3 4
| SELECT [Export 4].Date AS DATP, [Export 4].[N° IE] AS TORO, [Export 4].[Nom taureau], Sum((([Export 3.Rejet]+1)*[Nb réel paillette])) AS DOSE, [Export 4].[MaxDeN° monte] AS EJ, [Export 4].[Export 2].Rejet AS EJR, [Export 4].[Export 3].Rejet, Avg([Export 4].[MoyenneDeMotilité AVC]) AS MAV, Avg([Export 4].[MoyenneDeMotilité APC]) AS MAP, Avg((100-[MoyenneDeSpzs morts APC])) AS MPO, "L91" AS LABO
FROM [Export 4]
GROUP BY [Export 4].Date, [Export 4].[N° IE], [Export 4].[Nom taureau], [Export 4].[MaxDeN° monte], [Export 4].[Export 2].Rejet, [Export 4].[Export 3].Rejet, "L91"
HAVING ((([Export 4].[MaxDeN° monte])=1) AND (([Export 4].[Export 2].Rejet)=1)) OR ((([Export 4].[MaxDeN° monte])=2) AND (([Export 4].[Export 2].Rejet)=2)) OR ((([Export 4].[MaxDeN° monte])=3) AND (([Export 4].[Export 2].Rejet)=3)) OR ((([Export 4].[MaxDeN° monte])=1) AND (([Export 4].[Export 3].Rejet)=0)) OR ((([Export 4].[MaxDeN° monte])=2) AND (([Export 4].[Export 3].Rejet)=0)) OR ((([Export 4].[MaxDeN° monte])=3) AND (([Export 4].[Export 3].Rejet)=0)); |
Partager