Ms access 2000 reports

[BN PATEL]

From various table in one file of MS Access 2000 file i want to generate report. in all table fields and data type are same but data are not linked with any another. Due to large size of database it was split in various table. In output reports required one text box where the value enter and pertaining to the value in any table data should be display.

[dsatino]

Obviously english is not your first language. Kudos though, most of us dumb Americans only speak one (which one is a different story).

In any case, I'm going to give you an answer based on my interpretation of your problem since I think you communicated it fairly well.

What you need is a simple SELECT query based on the tables you need. Link these tables using whatever the common field is and put [Enter Parameter] in the criteria for the field in which you wish it to base the results upon.

From there you can build the report based on the query.

[MMcCarthy]

You could try a UNION query as the basis for your report.

SELECT a.Field1, a.Field2 
FROM MyTable1 AS a
WHERE a.Field1 ='SomeValue'
UNION
SELECT b.Field1, b.Field2 
FROM MyTable2 AS b
WHERE b.Field1 ='SomeValue'
UNION
SELECT c.Field1, a.Field2 
FROM MyTable3 AS c
WHERE c.Field1 ='SomeValue'

Get the idea?

[dsatino]

Ah, I think MMcCarthy has a better interpretation of your tables in your database than my original concept of your structure.