Query Criteria - overriding the results of one criteria (IIF statement?) (1 Viewer)

mscraftyannie

Registered User.
Local time
Today, 02:31
Joined
Feb 10, 2015
Messages
11
I have a weekly report I'm supposed to create for my boss. I need to query a simple table showing everything completed for the week in addition to everything that isn't 100% complete yet.

I have two fields: [% Complete] and [Start Date].
The [% Complete] should be anything less than or equal to 100%.
The [Start Date] is defined by a user entry when the query is run.

The problem is that sometimes the items that are <=100% are for days earlier than the start date given.

I'm fairly new to this, but do have some experience (not totally wet behind the ears). How can I make this query work?

I've attached my Query Design (albeit I didn't include the = in the %Complete field - oops), and I've attached what the data should look like in the end.

Any help you can offer will be greatly appreciated.
 

Attachments

  • Query Results.png
    Query Results.png
    81 KB · Views: 123
  • Query.png
    Query.png
    16.3 KB · Views: 122

JHB

Have been here a while
Local time
Today, 10:31
Joined
Jun 17, 2012
Messages
7,732
Remove the criteria for the % complete.
In the Complete Date:
>=[Start Date]
And in the next line (Or)
Is Null
 

Attachments

  • Cri.jpg
    Cri.jpg
    8.3 KB · Views: 276

mscraftyannie

Registered User.
Local time
Today, 02:31
Joined
Feb 10, 2015
Messages
11
Thank you, thank you, thank you!
 

Users who are viewing this thread

Top Bottom