Criteria in query based on option box on form

[magicdds]

I have a query that is used as the record source for a report (That prints
statements). The query has columns 0 to 30 Days, 31 to 60 Days, 61 to 90
Days, 90+ Days. Each row in the query displays a different customer, and the
query shows how much money is past due for each customer, for how many days.

I have a form with an option box that I can check off:
all accounts (option 1)
31 day old accounts (option 2)
61 day old accounts (option 3)
91+ day old accounts (option 4)

So I can limit which customers I want to send statements to, depending on
how old the past due account is. I can't figure out how to specify in the
criteria of the query that for example if I check off option 3 in the form,
then the query only returns the records for customers where the 61 to 90 Days
field and the 90+ Days field are greater than 0.

Can anyone help me with how to do this?
Thanks,
Mark

 

[KARL DEWEY]

I think you need to make copies of the query and report just for this kind of
reporting.

I assume that the query 0-30, 31-60, etc contain some data if that customer
has past due. What does that information look like?