MS access - help με κώδικα σε VB

[Bspus]

nai alla exo ena pedio date se kathe pinaka vasi toy opioy thelo na taksinomounte ta silegomena stoixeia ston kenourgio pinaka....dld ta dates apo kathe pinaka thelo na mazeyonte ola se ena alo pedio oste na taksinomounte meta oi egrafes vasi toy kenourgioy , sinolikoy date... px mporo sto SELECT na paro oti pedia thelo apo osous pinakes thelo ...alla exo to apotelesma :

------------------------------------------------------------

100 || 12/09/06 || epitagi || 200 || 13/06/06 || gramatio

------------------------------------------------------------

 

eno ego thelo :

----------------------------

200 || 13/06/06 || gramatio

100 || 12/09/06 || epitagi

-----------------------------

 

Kai auto akribos tha pareis me to union select. An psaxeis ligo tha to vreis. Ena aplo union select einai:

 

select num, sum, date from check

union select num, sum, date from this_table;

 

To parapano einai ENA sql statement, giauto exei ena mono ; sto telos.

Fysika mporeis na exeis osa union thes mesa, mono sto telos erotimatiko

Ypotheto oti exeis ena pinaka this_table me ta pedia num sum kai date

 

Ama ftaseis mexri edo meta ftiaxneis ena akoma query gia to order by date kai katharises.

Telos panton, opos se voleuei.