ELECT [IDE ].ID, [IDE ].Project, [IDE ].Number, [IDE ].Meeting,
[IDE ].[ISSUE
/ ACTION ITEM], [IDE ].[POC(1)], [IDE ].[POC(2)], [IDE ].[DATE OPENED],
[IDE
].[DUE DATE], [IDE ].[TARGET CLOSE DATE], [IDE ].[ISSUE ACTION STATUS],
[IDE
].[ISSUE STATUS (Current + Historical)], [IDE ].URL, [IDE ].Lupdate, [IDE
].[ISSUE STATUS (Current + Historical)], [IDE ].STATUS
FROM [IDE ]
WHERE ((([IDE ].[DUE DATE])>=Date()-7) AND (([IDE ].[ISSUE ACTION
STATUS])="O"))
ORDER BY [IDE ].[DUE DATE];
Thanks for the help..
Jeff Boyce said:
What is the SQL statement of the query you are using now...?
--
Regards
Jeff Boyce
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
.