• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

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

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
lehi52
Asked:
lehi52
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
create a query like  "query1" and use it as the record source of your report
2.accdb
0
 
lehi52Author Commented:
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
 
lehi52Author Commented:
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
 
lehi52Author Commented:
Rey was very helpful.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now