On Sat, 8 May 2010 03:21:01 -0700, Ahmed Saleem <Ahmed
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
You'll need to post some more information for anybody to have even a chance of
doing so.
If you have two tables in a query without joins, this is expected behavior:
every record in one table will be paired with every record in the other table
in all possible combinations. That's how queries work.
If you want one report showing all the data from one table or query, and then
all the data from another table, consider using a Report with two Subreports.