It certainly sounds possible, however you might want to elaborate on what you mean by "elapsed 3 days"...
- Faults that lasted 3 days or more?
- Faults that happened 3 days prior and/or post the date reported?
- Faults that are still occuring on the date entered?
Thanks for posting that. Now I think we have all the information we need to get the result you're wanting
So let's go through the logic of this again:
We want to return all faults that are not resolved (how do we identify this?) and where the date reported is 3 or more days ago (based on todays date) EDIT: changed the wording of "all results" to "all faults"
Ok, sounds like we have enough to begin with.
So now's your chance to shine!
I want you to write me 2 queries:
1) One that returns all faults with their status saying "Unresolved"
2) One that returns all faults that were logged more than 3 days ago (so use the date 22/04/2007)
Think you can manage that?
Your first query is bang on, but you tried 3 steps at once for your second!
Let's redo the second one, but let's get all faults that were reported today. (hint: What's the Access function for returning todays date?)