Filter Query via Tickbox

[Guest]

Hello All
I am trying to generate a query that populates when a tick box called
Declined <28% is ticked. Those boxes that are not ticked are not to appear on
the query.

Can someone please help me???

Thanks

 

[Duane Hookom]

A tick box (check box) is normally a control on a form. Is there a form
involved? Are there some names of fields, controls, tables, etc that you
could share?

 

[Guest]

Duane

The "Data Entry" table contains the Tick box called "Declined <28%" I have
created a query called "Declined <28% Report"

I want to eventually generate a report that shows a list of declined loan
applications where the Declined <28% tickbox is checked. All other declined
apps that do not have the tick box checked are not to appear on the report.

Hope this helps you.

 

[Duane Hookom]

Consider finding a standard naming convention methodology.

You can create a query where the criteria under the field [Declined <28%] is
either True/-1 or False/0.

 

[Guest]

Thanks Duane

Report is working correctly!

Consider finding a standard naming convention methodology.

You can create a query where the criteria under the field [Declined <28%] is
either True/-1 or False/0.

--
Duane Hookom
MS Access MVP

Duane

The "Data Entry" table contains the Tick box called "Declined <28%" I have
created a query called "Declined <28% Report"

I want to eventually generate a report that shows a list of declined loan
applications where the Declined <28% tickbox is checked. All other
declined
apps that do not have the tick box checked are not to appear on the
report.

Hope this helps you.