Solved

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

Posted on 2014-02-05
4
254 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

732 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