How to fetch data from two table with comparision between date and column
Posted on 2010-11-08
I have two table No. 1 check Drawn Statement(CDS Table) 2nd One is Bank Statement table.
Table No. 1 field is as below :-
DATE Office CODE office NAME CHEQUENO AMOUNT
Table 2 field is as below :-
Date Cheque No. Amount
Both the table have data of months sep, oct, nov.
As u see both the table have cheque no field is comman.
Now I want a report of unmatched cheque of particular month. Say I want to report of month 9/2010. I want to know that which cheque issued in the month of 9/2010 but they don’t Appear in the month of 9/2010 in the bank statement. Similarly I want which cheque issued in the month of 9/2010 and they present in the bank in the month of 9/2010.
1. Unmatched cheque report of 9/2010 out three months.
2. Matched cheque report of 9/2010 out three months.
I want to do this in ms access please tell me the query of these reports.