unable to pick up certain records

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

hi there,

i've created a query that gives me 43 records. somehow,
when i run that query against a table, 3 records are not
picked up in the query (although the join fields are
exactly the same i.e value, properties, format etc).

i've tried converting the first query into a make table
query and created the table for the 43 records. but when i
did a query based on the new table, the same 3 records
were not picked up.

any clues?

thanks.
 
i've created a query that gives me 43 records. somehow,
when i run that query against a table, 3 records are not
picked up in the query (although the join fields are
exactly the same i.e value, properties, format etc).
Click to expand...

Now wait a minute. This isn't making sense.

The query gives 43 records when you run it (against a table, since a
query without a table is nonsensical).

It gives 40 records when you run it (against... what? another table?).

Which is it!?

What are you doing the two "runs"? Could you post the SQL of the
query?
 
John Vinson said:
Now wait a minute. This isn't making sense.

The query gives 43 records when you run it (against a table, since a
query without a table is nonsensical).

It gives 40 records when you run it (against... what? another table?).

Which is it!?

What are you doing the two "runs"? Could you post the SQL of the
query?
Click to expand...
I assume the base tabel is 43 records but the query (with joined tables)
produces 40 records.
My guess is that some join fields contain null values and thus don't produce
a record in
full join select. My suggestion is to try an outer join on the tables.
 
Back
Top