1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
g_strSql = "SELECT id_demande, point, montant_poursuite, nom, prenom, " _
& "nb_pers, personne_attendue, suppl_mono, nb_enfant, nb_tiers, " _
& "nb_persRelle + NVL(suppl_mono,0) NbPersRepresentative, " _
& "nb_PersRelle, " _
& "date_anciennete, motif_valable, nb_pc_act, nb_pc_dem, rev_annuel, " _
& "no_logement, grp_immeuble, ord_immeuble, categ_immeuble, " _
& "enc_med_soc, acc_ch_rou, ascenseur " _
& "FROM v_Selection " _
& "WHERE " _
& "rev_annuel > " & (lngLoyerAn * 3) & " " _
& "AND " & Replace(dblNbPiece, ",", ".") & " <= nb_PersRelle + 2 " _
& "AND " & Replace(dblNbPiece, ",", ".") & " >= nb_pc_dem "
g_strSql = g_strSql & "ORDER BY point DESC, NbPersRepresentative DESC, Format(date_anciennete,''YYYYMMDD''), nom ASC" |
Partager