A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

i want to know more about report



 
 
Thread Tools Display Modes
  #1  
Old February 13th, 2010, 01:33 PM posted to microsoft.public.access.tablesdbdesign
Kutty
external usenet poster
 
Posts: 74
Default i want to know more about report

I want to know more about report to automate my database in msaccess.
Presently my main problem is I don't know how to group in print output
of invoice which I created. The reason is as I am aware I don't know what
is group in msaccess report. Please comment.
  #2  
Old February 13th, 2010, 02:54 PM posted to microsoft.public.access.tablesdbdesign
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default i want to know more about report

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."




"Kutty" wrote in message
...
I want to know more about report to automate my database in msaccess.
Presently my main problem is I don't know how to group in print output
of invoice which I created. The reason is as I am aware I don't know what
is group in msaccess report. Please comment.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.