item does not exist in database

J

JD Speckmann

I have a data base and need to include delinquent account data in a query &
report. I can generate a key to find the data if it exists (week # 1-52 &
Unit # 101-125), ex 27113. The delinquency report is an excel spread sheet
containing only delinquent accounts. I still need to display all the other
info even if this account is not delinquent. Any Suggestions?

Jim
 
J

Jerry Whittle

If you are joining the two tables in a query, try clicking on the line
between the tables while in design view until a dialog box shows. Try the
second option. If that doesn't work, try the third options.

The first option is an Inner Join. There must be a matching record in both
tables for a record to display. The second option is a Left join which allows
records to show even if the second table doesn't have a match. The third
option is a Right join which returns records even if there isn't a match in
the first table.
 

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

Compare same data of column in two workbooks 1
compare same data of column in two workbooks 0
subreport field does not exist 2
Highlighting rows in a range where ID code does not exist in secondrange... 4
Invoice database / report question. 7
Help with a Form based off of a Table 1
Corrupt Database does not show in database utility 0
Corrupt Database does not show in database utility 3

Top