=?Utf-8?B?QWhtZWQgU2FsZWVt?= wrote:


i design a report with access database i prepare a query with two table
without joinning but the query return data more than one time

Please solve my problem as soon as possible

If you don't join or cannot join the tables, a query will return any
combination of records in your tables. So if table 1 as 10 records and
table 2 has 5, the result in the query will be 50 rows, because you
don't tell Access (by joiningg on certain fields) which records belong
to each other.

--
Groeten,

Peter
http://access.xps350.com