D
Dawn
Dear all,
My mother-tongue is not english.So if there's something I cann't express
clear,pls be tolerant,thanks.
There are two tables,with the same field definations, but not all same
records.assuming table A is a snapshot of 2008-2-29,Table B is a snapshot of
2008-3-21.the key field in both table is AccountNO.
I try to use access 2003 to find out what accounts have been opened between
2008-2-29 and 2008-3-21.
Up to now ,I only have the experience to use the parameter "join",but this
case,I need to find out the difference.
Can u do me a favor ,as to show me how to solve it in access 200? ?
pls also give me a sql sentence.
many thanks.
My mother-tongue is not english.So if there's something I cann't express
clear,pls be tolerant,thanks.
There are two tables,with the same field definations, but not all same
records.assuming table A is a snapshot of 2008-2-29,Table B is a snapshot of
2008-3-21.the key field in both table is AccountNO.
I try to use access 2003 to find out what accounts have been opened between
2008-2-29 and 2008-3-21.
Up to now ,I only have the experience to use the parameter "join",but this
case,I need to find out the difference.
Can u do me a favor ,as to show me how to solve it in access 200? ?
pls also give me a sql sentence.
many thanks.