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
lehi52Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor 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
All Courses

From novice to tech pro — start learning today.