Query Returning No Results

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
 
J

Jeff Boyce

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query return duplicate results 1
Dcount returning no results!!! 0
Query not returning results 9
DSum 3
Access Daily Entry with multiple entries per field 0
query 1
Getting only the last transaction for each customer 1
Update Query - Want to Update Only the First Match 4

Top