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.
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.