Additions from form not in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I set up a database with two tables and did a query covering both tables.
I also set up a form to populate the two tables. When I go back to the
query to query for the new entries, the entries are not there and I cannot
seem to get them in a new query or report.

I had this happen once before and the answer I know is simple, but it was a
long time ago and I don't remember.
 
If the queries link the two tables together, it's probably with an INNER
JOIN. In that case to return records BOTH tables need to have a record with
the joined fields. If either are missing a matching record, there will be
nothing returned for that record.

You probably need a Left or Right join. In query design view, double click
on the line between the two tables. When the dialog box appears, select
Option 2 or 3 and see if that fixes the problem.
 
Thank you. I will try it.
--
Carol


Jerry Whittle said:
If the queries link the two tables together, it's probably with an INNER
JOIN. In that case to return records BOTH tables need to have a record with
the joined fields. If either are missing a matching record, there will be
nothing returned for that record.

You probably need a Left or Right join. In query design view, double click
on the line between the two tables. When the dialog box appears, select
Option 2 or 3 and see if that fixes the problem.
Click to expand...
 
Back
Top