1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Private Sub Visualisation_Click()
On Error GoTo Err_Visualisation_Click
Dim stDocName As String
stDocName = rqt
DoCmd.OpenQuery stDocName, acNormal, acEdit
Exit_Visualisation_Click:
Exit Sub
Err_Visualisation_Click:
MsgBox Err.Description
Resume Exit_Visualisation_Click
End Sub
pour la requête, celle avec deux critère parametrés:
SELECT [TABLE ARTICLES].[Mode OMEGA], [TABLE ARTICLES].[Code Rayon], [TABLE ARTICLES].Grossiste, [TABLE ARTICLES].Fournisseur, [TABLE ARTICLES].Appli, [TABLE ARTICLES].[Maj article], [TABLE FOURNISSEURS].[Code Omega], [TABLE ARTICLES].[Code UG], [TABLE NOMENCLATURE].Lib_UG, [TABLE ARTICLES].[Statut article], [TABLE ARTICLES].Désignation, [TABLE ARTICLES].[Marque Commerciale], [TABLE ARTICLES].[Poids vol unitaire], [TABLE ARTICLES].Colisage, [TABLE ARTICLES].DLC, [TABLE ARTICLES].TVA, [TABLE ARTICLES].EAN, [TABLE ARTICLES].CB1, [TABLE ARTICLES].[PA cession mag], [TABLE ARTICLES].SVAP, [TABLE ARTICLES].[PV base TTC], [TABLE ARTICLES].PK, [TABLE ARTICLES].[Taux marque PV base TTC]
FROM [TABLE NOMENCLATURE] RIGHT JOIN ([TABLE ARTICLES] LEFT JOIN [TABLE FOURNISSEURS] ON [TABLE ARTICLES].Fournisseur = [TABLE FOURNISSEURS].Fournisseur) ON [TABLE NOMENCLATURE].UG = [TABLE ARTICLES].[Code UG]
GROUP BY [TABLE ARTICLES].[Mode OMEGA], [TABLE ARTICLES].[Code Rayon], [TABLE ARTICLES].Grossiste, [TABLE ARTICLES].Fournisseur, [TABLE ARTICLES].Appli, [TABLE ARTICLES].[Maj article], [TABLE FOURNISSEURS].[Code Omega], [TABLE ARTICLES].[Code UG], [TABLE NOMENCLATURE].Lib_UG, [TABLE ARTICLES].[Statut article], [TABLE ARTICLES].Désignation, [TABLE ARTICLES].[Marque Commerciale], [TABLE ARTICLES].[Poids vol unitaire], [TABLE ARTICLES].Colisage, [TABLE ARTICLES].DLC, [TABLE ARTICLES].TVA, [TABLE ARTICLES].EAN, [TABLE ARTICLES].CB1, [TABLE ARTICLES].[PA cession mag], [TABLE ARTICLES].SVAP, [TABLE ARTICLES].[PV base TTC], [TABLE ARTICLES].PK, [TABLE ARTICLES].[Taux marque PV base TTC]
HAVING ((([TABLE ARTICLES].[Code Rayon])=[Formulaires]![Mercuriale]![P2]) AND (([TABLE ARTICLES].Fournisseur)=[Formulaires]![Mercuriale]![P1]))
ORDER BY [TABLE ARTICLES].[Code Rayon], [TABLE ARTICLES].Fournisseur; |
Partager