1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| SELECT 1 as ordre, [civil_a] & " " & [donateur_a] AS [Date du reçu], "" AS [Date du don], "" AS [Nature du don], "" AS [Poids en Kg], "" AS Kilos, "" AS Quantité, "" AS Conditionnement
FROM rq_pour_liste_selective_8 order by ordre
UNION
SELECT 2, [adr_a] AS [Date du reçu], "" AS [Date du don], "" AS [Nature du don], "" AS [Poids en Kg], "" AS Kilos, "" AS Quantité, "" AS Conditionnement
FROM rq_pour_liste_selective_8
UNION
SELECT 3, [date_t] AS [Date du reçu], "" AS [Date du don], "" AS [Nature du don], "" AS [Poids en Kg], "" AS Kilos, "" AS Quantité, "" AS Conditionnement
FROM rq_pour_liste_selective_8
UNION
SELECT 4, rq_pour_liste_selective_8.date_a AS [Date du reçu], rq_pour_liste_selective_8.date_don_a AS [Date du don], rq_pour_liste_selective_8.nature_don_a AS [Nature du don], rq_pour_liste_selective_8.qté_don_a AS [Poids en Kg], rq_pour_liste_selective_8.condi AS Kilos, "" AS Quantité, '' AS Conditionnement
FROM rq_pour_liste_selective_8
WHERE (((rq_pour_liste_selective_8.condi)="Kg"))
UNION SELECT 5, rq_pour_liste_selective_8.date_a AS [Date du reçu], rq_pour_liste_selective_8.date_don_a AS [Date du don], rq_pour_liste_selective_8.nature_don_a AS [Nature du don], "" AS [Poids en Kg], "" AS Kilos, rq_pour_liste_selective_8.qté_don_a AS Quantité, rq_pour_liste_selective_8.condi AS Conditionnement
FROM rq_pour_liste_selective_8
WHERE (((rq_pour_liste_selective_8.condi)<>"Kg")); |
Partager