Solved

Create a list with field but only for those who are check mark

Posted on 2014-02-05
4
252 Views
Last Modified: 2014-02-19
I am working on a database.   I would like to create a report that adds these fields (Effective date, EPLI Policy #, Policy Name,  Premium onto a report)  I would only like to add the information if the EPLI box is checked.  Then I need to be able to see the report for only certain months.  How do you do this.  I attached a sample database so you can see what I am referring to.
1.accdb
0
Comment
Question by:lehi52
  • 3
4 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39836480
create a query like  "query1" and use it as the record source of your report
2.accdb
0
 

Author Comment

by:lehi52
ID: 39836523
The report seems to be working in reverse order. If you check the EPLI Box they come off a report rather than added onto a report.
0
 

Author Comment

by:lehi52
ID: 39836614
Rey,  I got it. The EPLI was marked to Zero. So I changed it to true in the criteria and it works now.  Thank you.
0
 

Author Closing Comment

by:lehi52
ID: 39836617
Rey was very helpful.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question