Criteria formula from control on form

  • Thread starter Thread starter Markus
  • Start date Start date
M

Markus

I have a column in my query for accounts #Days Past Due. I
want the information queried depending on criteria chosen
from a control on the form.
1= Less Than 10
2= More Than 10
3= Between 10 and 30
4= More Than 30
5= All

Here is what I tried in the ctriteria section of the
queryu but it does not quite work correctly. Especially
for value 3.

Like IIf([forms]![Summary]![DaysPast]=1,>10,IIf([forms]!
[Summary]![DaysPast]=2,<10,IIf([forms]![Summary]=3,>10 And
<30,IIf([forms]![Summary]=4,<30,IIf([forms]![Summary]
=5,"*")))))
 
Hi,


Make a computed column:

Choose( FORMS!Summary!DaysPast, DaysPastDue<10, DaysPastDue>10, DaysPastDue
BETWEEN 10 AND 30, DayPastDue>30, True)



and add the criteria:

<> False


Hoping it may help,
Vanderghast, Access MVP
 
Hi,


Make a computed column:

Choose( FORMS!Summary!DaysPast, DaysPastDue<10, DaysPastDue>10, DaysPastDue
BETWEEN 10 AND 30, DayPastDue>30, True)



and add the criteria:

<> False


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top