?There's a new table for each course? That sounds like a spreadsheet, not a
relational database.

If there is one table per course, my first recommendation is to review
"normalization" and "relational database design". In a well-normalized
Access database/application, you'd probably need only ONE table for course
information. That would seem to make querying much easier.

To combine data from one table to another, please see my previous response.
If you are saying "database" but meaning "table", you wouldn't have to link
to the other database before creating a query that appends data from one to
another.

NOTE: backup, backup, backup, before running an append query or any other
function that alters data.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"sweetummy" wrote in message
...
Hi,

The database belongs to voluntary organization - Higher education
grant for poor students the organization helps for their education. In
the mean time 5 years back one of my senior collegue designed a
database with some basic database knowledge..

About the database: According to their courses the tables are designed
for each course he created a new table to enter the data.. There are
nearly 10 different courses with the same fields using with mail merge
option we used to take prints and send them to field offices loacted
in their areas.. so we need to enter the details according to their
personal details and amount given to them according to their academic
year..
i have designed the reports how i need it.. but i have nearly 10
thousands of records in the file now i want to merge the whole data..

The main two drawbacks are
1. we are unable to extract the data what we want...
2. As the data is enormous we are unable to merge the whole data in
one table as their id are autonumbers and the same numbers are in
other tables also..
3. for each year we have to add the academic year and expenditure of
the present year other wise we cannot extract the record..

so i'm in great confusion to get the data properly..
if you can see the data and its structure of old and new and other
word documents given you can get a clear idea to explain back to me..

thank you once again..

bye..