If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
two access table in one query
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 |
#2
|
|||
|
|||
two access table in one query
=?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 |
#3
|
|||
|
|||
two access table in one query
|
Thread Tools | |
Display Modes | |
|
|