Kutty,
This question is too broad for a specific answer. I would first suggest
a good beginner's Access reference manual, and /or a local tech school
or community college course in Access... if available.
First, your table, and more often, the query behind your report, is used
to deliver all the records to the report... using your criteria. How that
data is organized on the report is controlled by the Sorting & Grouping
dialog box of Report Design.
Groups are a logical hierachy of related data, used to display data in a
rational and organized manner. The same data can be grouped in
different ways depending on the purpose of the report.
The primary tool for report grouping is the Grouping & Sorting dialog
box in
report design view.
Example: An address database listing.
Using Grouping & Sorting you might not group at all... just list by
Name ascending. Like an address book
Adams Bill 14 Main St ......
Baker Mary 8 Elm Ave ....
etc...
Another report might be grouped by State, and City, and Name
New York ' State group
Troy ' City group
Adams Bill 14 Main St ...... 'Detail section (Name)
Albany
Baker Mary ....
Labels for that data might be grouped by ZipCode.
etc... etc... for whatever purpose you develop a report.
Determine what your report is meant to accomplish.
Determine what would be the best/most efficient way to organize and
display that data.
Use Grouping and Sorting to accomplish that.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
