Why is this coming out different??

  • Thread starter Thread starter Maximus
  • Start date Start date
M

Maximus

I have a field named DaysPast in my query. When I enter
criteria into the query such as >10 I get all the records
that are greater than 10 days. If I attempt to use an Iif
statement to reference a control on the form such as
Iif([forms]![summary]![DaysPast]=3,>10) I only return
records where the DaysPast equals 0. Am I missing
something?
 
Back
Top