Solved

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

Posted on 2014-02-05
4
246 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 119

Accepted Solution

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

Author Comment

by:lehi52
Comment Utility
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
Comment Utility
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
Comment Utility
Rey was very helpful.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
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…

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now