Query Returning No Results

  • Thread starter Thread starter Becky Lacy
  • Start date Start date
B

Becky Lacy

I'm trying to create a query based on two tables.

Table 1
Date Entered and Deposit Amount

Table 2
Transaction Date and Transaction Amount

I've set both date field with Date()

The problem is when there are no entries for the current
date in one of the tables the query brings back no results
even if there are entries in the other table. It works
fine if there are entries in both tables.

Any help on this is greatly appreciated.

RL
 
Becky

From your description, the only field that could possibly tie the tables
together is the date field. To build a query based on two (joined) tables,
you need a field in common.

More info, please...

Jeff Boyce
<Access MVP>
 
Back
Top