i want to know more about report
in [Tables]
|
From: Kutty on 13 Feb 2010 07:33 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.
From: Al Campagna on 13 Feb 2010 08:54 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" <Kutty(a)discussions.microsoft.com> wrote in message news:39CC9653-6815-4038-B9B4-2F5182824EB7(a)microsoft.com... >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.
|
Pages: 1 Prev: No duplicates wanted in column except for default value... Next: Pen Mode in Access 2007 |