problems with query

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

Steven

hi there,

i created a query (Q1) which gave me a results of 43
records. when i used Q1 to do another query with the same
values, it came only picked 40 records, and 3 of the
records where not matched.

i've checked the format, properties and value of the 3
records, and they are identical, but somehow, it doesn't
pick up on those records. i've also tried making Q1 into a
make table query, and created table (T1) which has 43
records. but when i did the query using T1, it didn't pick
up on the similar 3 records.

any clues?
 
i created a query (Q1) which gave me a results of 43
records. when i used Q1 to do another query with the same
values, it came only picked 40 records, and 3 of the
records where not matched.
Click to expand...

I'm sorry, Steven, but this doesn't make any more sense now than when
you posted it this afternoon.

Please post the SQL of Q1, and explain what you mean by "I used Q1 to
do another query".
 
Back
Top