item does not exist in database

  • Thread starter Thread starter JD Speckmann
  • Start date Start date
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
 
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.
 
Back
Top