Why is this coming out different??

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria formula from control on form 2
Nested Iif Formula Question 3
Query Criteria 3
Date comparison in IIF statement in a query 1
Parameter Query based on Form 2
IIf Statement Error 3
Between date with greater than or eaqual to 4
How do I run a query using multiple conditions? 1

Top