SELECT france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs, doubles.neufs_sc, doubles.neufs_ac, doubles.neufs_sg, doubles.obliteres, doubles.surlettre, cotations2001.neuf, cotations2001.neufaveccharniere, cotations2001.nsg, cotations2001.oblitere, cotations2001.lettre FROM (France LEFT JOIN doubles ON france.dallay= doubles.dallay and no_adherent = #session.NoMembre#) LEFT JOIN cotations2001 ON france.dallay=cotations2001.dallay Where left(france.dallay,1) < 'A' and anneeemission between '1849' and '1899' between '1900' and '1919' between '1920' and '1929' between '1930' and '1939' = '#Annee#' AND (designation like '%#Motcle#%' OR designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%' OR valeurfaciale like '%#Motcle#%' OR couleurs like '%#Motcle#%') order by ordre UPDATE doubles SET neufs_sc=#numberformat(evaluate("form.NSC"&Dallay1))#,neufs_ac=#numberformat(evaluate("form.NAC"&Dallay1))#, neufs_sg=#numberformat(trim(evaluate("form.nsg"&Dallay1)))#,obliteres= #numberformat(trim(evaluate("form.Obli"&Dallay1)))#, surlettre=#numberformat(trim(evaluate("form.SurL"&Dallay1)))# Where no_adherent=#Session.NoMembre# and dallay='#qTimbres2.dallay#' Delete from doubles where dallay='#Dallay#' and no_adherent = #session.NoMembre# Insert into doubles (no_adherent, dallay, neufs_sc, neufs_ac, neufs_sg, obliteres, surlettre) VALUES (#Session.NoMembre#, '#Dallay#', #numberformat(trim(evaluate("form.NSC"&Dallay1)))#,#numberformat(trim(evaluate("form.NAC"&Dallay1)))#,#numberformat(trim(evaluate("form.nsg"&Dallay1)))#,#numberformat(trim(evaluate("form.Obli"&Dallay1)))#,#numberformat(trim(evaluate("form.SurL"&Dallay1)))#) Philatélix SELECT * FROM profils where nochrono=#Session.NoMembre# SELECT france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs, doubles.neufs_sc, doubles.neufs_ac, doubles.neufs_sg, doubles.obliteres, doubles.surlettre, cotations2001.neuf, cotations2001.neufaveccharniere, cotations2001.nsg, cotations2001.oblitere, cotations2001.lettre FROM (France LEFT JOIN doubles ON france.dallay= doubles.dallay and no_adherent = #session.NoMembre#) LEFT JOIN cotations2001 ON france.dallay=cotations2001.dallay Where left(france.dallay,1) < 'A' and anneeemission between '1849' and '1899' between '1900' and '1919' between '1920' and '1929' between '1930' and '1939' = '#Annee#' AND (designation like '%#Motcle#%' OR designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%' OR valeurfaciale like '%#Motcle#%' OR couleurs like '%#Motcle#%') order by ordre
Doubles : Année 1849 à 18991900 à 19191920 à 19291930 à 1939#Annee#


Année:
N° Philatelix
Désignation
Chercher :  
Neuf ** Neuf * Neuf (*) Oblitéré Sur lettre
#Dallay# #trim(designationcourt)#, #ValeurFaciale#, #Couleurs#
Aucun timbre trouvé #nodebut# à #evaluate(nodebut+29)##qTimbres.recordcount# sur #qTimbres.recordcount# trouvés

 Page 1 #numberformat(I+1)#