Access database strange behaviour query - 1 attachment

[Maurice Mertens]

Hi,

having a database with strange behaviour. Attached is db3.mdb, which has
two tables and 1 query.

When you execute the query (Query1) the query returns 392 records. If you
sort a column in the query result screen the number of results drop to 42.
This is very strange,

Also, if you see the ammount of records in both tables, I cannot understand
how it can return 392 rows.

Can someone help me with this problem?


--
Met vriendelijke groet / With regards / Saludos,
Moviat Automatisering


Maurice Mertens
mauricem@moviat_KillSpamWordForEMail.nl

tel: +31 162 470 534
fax: +31 162 470 502

 

[John Vinson]

Hi,

having a database with strange behaviour. Attached is db3.mdb, which has
two tables and 1 query.

When you execute the query (Query1) the query returns 392 records. If you
sort a column in the query result screen the number of results drop to 42.
This is very strange,

You didn't attach the database - which is a good thing; binary
attachments are not appropriate or welcome on the newsgroups!

Please open Query1 in SQL view and post the SQL text here. I suspect
you have an improper JOIN or perhaps no join at all.

John W. Vinson[MVP]