Please review normalization and relational database design. You can try to
make your database structure match the reports you want, but that is a
little like trying to use a bicycle to pull a train...

Instead, first get the data structure designed in a way that Access can use
(i.e., normalized), then use queries to pull the pieces of data you wish to
display in a report.

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 ,
thank you for replying me..

Yes, thats why i've started renewing the database to new.. even that
too useful some extent... we used to call that data by mail merging
the each table in ms-word. so it would be easier for us to distribute
the reports to the areas.. but its very hard to calculate the
expenditures and other advnced features..

thank you for your valuble tip.. i have made synchonised the required
fields to 3 tables..

1. Students table.
subform table.. (inclusive course details)
2 Course Table
3. AreaRegions Table..

the tables are related logically according to reports how we want..
you can see the picture here..

http://sites.google.com/site/gsvfilm...attredirects=0
(no need to take risk its simple as photo)

The main form will be like this..
http://sites.google.com/site/gsvfilm...attredirects=0

i got a doubt in main form .... I would like to trim it to some fields
like
trans_id, student_id, course, expenditure only not the whole course
table...

if the user tick the mark one more form should be displayed to enter
the higher education details.. is it better or only 1 sub form is
enough..

as you have seen the data is like a speadsheet , so i would like to
cross tab to suit my database design..

please suggest me..