Create a simple report

You can create a variety of different reports in Microsoft Office Access 2007, ranging from the simple to the complex. Begin by thinking about your report's record source. Whether your report is a simple listing of records or a grouped summary of sales by region, you must first determine which fields contain the data you want to see in your report, and in which tables or queries they reside.
After you choose your record source, you will usually find it is easiest to create your report by using the Report Wizard. The Report Wizard is a feature in Access that guides you through a series of questions and then generates a report based on your answers.
What do you want to do?
* Choose a record source
* Create a report by using the Report tool
* Create a report by using the Report Wizard
* Create a report by using the Blank Report tool
* Understand the report sections
* Understand controls
* Fine-tune your report in Layout view
* Fine-tune your report in Design view
* Add controls to the report
* Save your work
* View, print, or send your report as an e-mail message

Sponsored Links:

Related Topics

Creating Simple Reports
You will build upon that knowledge to create an actual report. In the simplest sense, a report is a formatted output of your data. Using reports, you can select the fields you want Access to print, as well as their formats.
By the time you finish this tutorial, you will understand the following key concepts: what a report is, ways to create reports, how to start the Report Wizards, the types of reports you can create with the Report Wizards, how to create a simple tabular report, how to create mailing labels.


Create a simple report in Access 2007
You can create a variety of different reports in Microsoft Office Access 2007, ranging from the simple to the complex. Begin by thinking about your report's record source. Whether your report is a simple listing of records or a grouped summary of sales by region, you must first determine which fields contain the data you want to see in your report, and in which tables or queries they reside.


How to create and print unique report for each entry?
Actually I am very very new to Access and I started learning by creating a very simple database for an event we are organizing. I have created a simple form to input the participantsand their details.I also created various queries and reports that categorize the participants according to a certain type.

I also need to create a simple report for each participant and I cannot find the way. This report must also be printed after each record is done.


Problem with Query, Relationships and Reports in Access 97
I know. I know. I am way behind the curve on versions of Access, however, my state government is holding me back. I am trying to create a simple report using data from two different tables with a simple one-to-many relationship. The first table is Manufacturers Name and address.

The second table is the manufacturers product list. The join is on the manufacturer's name. For some reason when I create my report, which is a simple letter with name address and list of their products, I get all the products in the database in the report.

I have tried changing the join types, with no luck. I am getting the right sub-totals by manufacturer, but the next manufacturer continues on the same page. I know that I am missing something simple.


Simple Way to Carry Over Value of Field to Next Form
I need to upload a database to Sharepoint, so essentially I have no relationships, just LookUp Fields.

I have two tables, both sharing the Report Number field, datatype AutoNumber.

I want to have the Report Number on the first form displayed. Once the user has finished filling out information they can click a button to go to the second form. The Report Number will no longer be displayed, but the forms will all be part of the same report.

I need to have a simple way (w/o VBA) to transfer the value of the Report Number to the second form so that it knows it is all part of the same report.

I know that I can create a drop-down box so the user can select the Report Number, but my fear is that if there is a lot of reports (and there will be) that they could potentially forget what Report Number is being used and start filling out the wrong one.

Is there a way to carry the Report Number value over to the next form simply? Maybe a macro could do this


Simple Way to Carry Over Value of Field to Next Form
I need to upload a database to Sharepoint, so essentially I have no relationships, just LookUp Fields.

I have two tables, both sharing the Report Number field, datatype AutoNumber.

I want to have the Report Number on the first form displayed. Once the user has finished filling out information they can click a button to go to the second form. The Report Number will no longer be displayed, but the forms will all be part of the same report.

I need to have a simple way (w/o VBA) to transfer the value of the Report Number to the second form so that it knows it is all part of the same report.
I know that I can create a drop-down box so the user can select the Report Number, but my fear is that if there is a lot of reports (and there will be) that they could potentially forget what Report Number is being used and start filling out the wrong one.

Is there a way to carry the Report Number value over to the next form simply? Maybe a macro could do this


Guide to designing reports
Microsoft Office Access 2007 provides you with a number of tools that help you to quickly build attractive, easy-to-read reports that present the data in a way that best suits the needs of its users. You can use the commands on the Create tab to create a simple report with a single click. You can use the Report Wizard to create a more complicated report, or you can create a report by adding all the data and formatting elements yourself. Whichever method that you choose, you will probably make at least a few changes to the design of the report to make it display the data the way that you want. This article discusses the general process of designing a report and then shows you how to add specific design elements to your report.


Report from database or query
I have created a report using the simple method from the table and also using the query. No matter what I do to get "new" data to display in the report it is always pulling in from my original creation.
This report will be used on a monthly basis so I want ht e report that I created using January data to be able to pull March data into the report. Simple, but I have tried several things and it is not working out.


Create A Report in MS Access 2003 Using Report Wizard
Microsoft Access is used within many businesses to store and access information. You can also create a simple report easily using the Report Wizard.


Filtering report
I know this is pretty simple but can't work out how to make it all work together.

I know how to filter a report using a form, I know how to create a report that shows counts rather than individual records, but I don't know how to produce a report that shows counts, with the ability to filter the data that is used to produce the counts (according to dates entered into a form).

Right now my access file is a simple table and form setup. A research assistant needs to enter details like whether the person was screened, did they pass the screen and so forth. I wantto produce a report that shows for example:


Report Filter by ComboBox
I'm trying to create a simple DB for tracking service calls. Everything is working how I want it with the exception of being able to create one report. I currently have a report called "Issues by Assigned To - Details", but I want to be able to run this report one "Contact" at a time.

I'm new to Access and can't for the life of me get this to work. I'd like to have a combobox in addition to my current report screen. This is built from the Microsoft "Issue Tracker" template.


Simple Report in Access 2007
This question pertains to a"Simple Report" made from a Crosstab Query and saved. Everything seems to work fine, except that if I modify the database in such a way that a field is added or deleted from the Query, the saved report when opened either fails to pick up the added field, or comes up with an error message saying it does not recognize the deleted field.

To get a correct report, I have to make a new"Simple Report" from the updated Query. Is there a way to fix this problem? I am using Access 2007.


Create an Access database/Excel workbook solution
Copy Excel customer data to Access, and then create a simple report by using the Report Wizard. Link to Excel customer data from Access, and then create a detailed report by using Report Layout view in Access. Import the Excel customer data into Access, delete the data from Excel, connect to the data in Excel, and then create a Split Form in Access. Collect new data from Access by using Outlook, create a query of customer addresses, and then create a mailing label report. Create a working database/workbook solution with a startup form and links to reports in Access.


Word and Bookmarks
I want to try and create a Word document from Access. Does anyone know where I can find a simple step by step example of how to do this using Words Bookmarks. OR give me a simple way to do it.

I have my report working in Access but I needed to have a content page which should go to relevant places in the document. Because my access report uses several sub reports it apparantly cannot do this, even if I export it to PDF or word it does not work with the hyperlinks

Example : Section 1 on content page shuld go to the Section 1 header (Page 5 of main report). I can only get the hyperlink to open the sub or main report and not go to a page when in the main report.

So I think WORD may be the way to go but not sure how to use it with bookmarks or how to make the link etc


Textbox and Label Inner Margins
The user may give importance mainly to the information contained in a Report and insist only on getting it in the right order and layout. But, how to present this to him/her is your responsibility alone and depends on how much time you have to work on it. You will be designing a Report only once and it is part of your Project, how you do it is your own choice. Here, I would like to introduce you to few Properties of Text Boxes and Labels on a Report and how simple design changes can transform it into a nice looking Report. The following is an image of a Tabular Report designed with the Report Wizard of MS-Access.


Manual selection of items, creating report from them..
Got a couple steps for what should be a simple issue, but me + Access do not = simple

Access '07, btw.

1. I need to create a form that lists all the Projects in my database. They need to have a check box next to them.

2. I need to be able to select multiple projects and then generate a report based on which projects are selected.

3. I need a report which shows the selected projects most recent update. I already have a query to do this, but it's not based off of the above form which limits the projects to only those selected


How to email a report to a list of emailusing outlook
I would like to email a report or form to a list of contacts.

I currently have the simple button that when clicked it opens access and I have to put the contact info, the subject, etc. myself.

this is the simple macro for EmailDatabaseObject.

But I would like the recipient info to be pulled from a seperate table not in the report. I tried doing To = ([TableOfEmails].[Emial]) but I get an errors.


How to create a chart in a report from calculated fields in (of that same report)
I have created a report (from a table) and some simple fields with calculations (counts, percentages, and averages). I want to create a chart of those calculated fields, but I cannot do it using the Chart Wizard because it only seems to allow me to use fields from Tables and Queries.

I did not have to create queries for this table because the report calculated the fields that I needed. Now, I just need a graphical representation of these calculated fields.

Is there any way to do it? If not, any other options that I could look into?


Bound Chart in Report Issues - Access 2007
I have a simple table, containing a count, a status and an agent name. I created a simple report, with a header by agent name.

Agent Name: Joe Blow
Simple bar chart - Horizontal Access Shows Status - In Progress, Complete, Not Started
The value will be the count

This will repeat for each agent. The report has groups, in the group header is the agent name and the chart is also in the header, the detail section is hidden.

The problem I am having is that when I view the report, the charts flashes on and off, as if it is a refresh issues. At first I uses a query as the source. I have since created a temp table as the source.


Runtime forms and report only
I have built a simple database for a client and create a runtime which all worked fine. I have a question that if I want to update forms and report or queries and then create a new runtime his data will be lost.

Can I create a runtime which uses the original database but updates the forms and reports etc.