1 2
| SELECT numero AS [N° adhérent], civilite AS Civilité, nom_adhe AS Nom, prenom AS Prénom, adresse AS [Adresse 1], adresse2 AS [Adresse 2], code_postal AS [Code Postal], ville, Format([Total_DistAR],"#\.# Kms") AS [Distance AR], coadherent AS Coadhérent, Format([Retenus],"#\.# Kms") AS [Pris en compte], Format([Montant],"#.00 ") AS [Montant à 0,30/km ], Format([Indemnites],"#,##0.00 ") AS Indémnités, Format([Arrondi],"#,##0.00 ") AS Apercevoir, NombrePR AS [Nbre de PR balisés]
FROM R_Indemnisations; |
Partager