Query Two Tables

[AOGFADUGBA]

Hi All, please is there a way to query two tables for records that falls between a date range.
The first table is for credit records and the second table is for debit records.
I want to create a cash book with the two tables. getting the credit record on one side and the debits record on another side of the query and all the records from the two tables must fall between the same date range. ie credit for march and debit for march.
can someone help. thanks

 

[alansidman]

What is the structure of each of the tables? ie. Field names? and table names?

 

[AOGFADUGBA]

Thanks for your resonse alansidman
Table1[payment] fields: date; voucherNo; paid to; details; amount; chequeNo; cash; Bank
Table2[Receipt] fields: date; voucherNo; Received From; amount; No On Bank slip; Cash; Bank
Thanks

 

[AOGFADUGBA]

i Missed the last fields dept No for both tables

 

[alansidman]

It does not appear that you have a relationship between the two tables as there does not appear that there are Primary Keys and Foreign Keys. As such, I would run a query on each table using the Between Function on the Date Field. Then create a Union Query joining the two queries that have the result you are looking for.

 

[AOGFADUGBA]

Thank was able to figure it out, created a union all query and i got all the dates from the two tables into one column, then i did a many to many query to get all the dates in the union all from both tables.
Thanks a lot