J
Jimmy
Hi
I have a three tables in the Access 2002
Tabel A
Invoice number
Date
Customer
Table B-Receipt
Invoice number
Paid Date
Customer
Table C-Receipt(2006)
Invoice number
Paid Date
Customer
I tried to create One query based on the Table A's Invoice number to match
with Table B and Table C in order to find out the Invoice of Table A (is it
paid and then when)
I cannot do it,
Please help
Thanks
Jimmy
I have a three tables in the Access 2002
Tabel A
Invoice number
Date
Customer
Table B-Receipt
Invoice number
Paid Date
Customer
Table C-Receipt(2006)
Invoice number
Paid Date
Customer
I tried to create One query based on the Table A's Invoice number to match
with Table B and Table C in order to find out the Invoice of Table A (is it
paid and then when)
I cannot do it,
Please help
Thanks
Jimmy