Creating Report from Multiple Tables (that have same format)

[itschen]

I have multiple tables in Access that have the same form/design (in terms of
columns and rows). I want to be able to create a report in the following way:

I will create a form which will ask the user to input the row number
desired. Since all the tables are identical in design, the report will
combine the row desired from every table. i.e. Row 30 from every identical
table;

I was wondering how I could accomplish this. I don't think I can do this
with a query, but maybe it can be done?

I was thinking I could merge all tables into one huge big table, but this
would complicate things a little too much, and it will be harder to analyze
the data this way.

Any help would be appreciated.

 

[KARL DEWEY]

desired.
This will be hard unless you have a field that includes a number for Row.
Access stores records like a barrel of bricks. When you pour them out they
are not in any set order unless you have a field to sort by.

Use a union query to pull the records from multiple tables.
No, just add a field that define the table, or whatever.