If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help..Need a report due within 7 Weekdays
I tried with all my efforts to create a report that is due within weekdays 7
days from today but no joy... I have a data element that states due date but cannot figure from the due date and todays date when is it due in a weekday not calendatr date... Thank You Al |
#2
|
|||
|
|||
Please help..Need a report due within 7 Weekdays
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. "AL Rios" wrote in message ... I tried with all my efforts to create a report that is due within weekdays 7 days from today but no joy... I have a data element that states due date but cannot figure from the due date and todays date when is it due in a weekday not calendatr date... Thank You Al |
#3
|
|||
|
|||
Please help..Need a report due within 7 Weekdays
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" wrote: 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. "AL Rios" wrote in message ... I tried with all my efforts to create a report that is due within weekdays 7 days from today but no joy... I have a data element that states due date but cannot figure from the due date and todays date when is it due in a weekday not calendatr date... Thank You Al . |
#4
|
|||
|
|||
Please help..Need a report due within 7 Weekdays
I'm not entirely clear on what you want to select...
Are you saying you want to see all records with a due date less than one week (7 days)? Or are you saying you want to see all records with a due date on a workday, plus less than 7 days away? Or ? More info, please... -- 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. "AL Rios" wrote in message ... 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" wrote: 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. "AL Rios" wrote in message ... I tried with all my efforts to create a report that is due within weekdays 7 days from today but no joy... I have a data element that states due date but cannot figure from the due date and todays date when is it due in a weekday not calendatr date... Thank You Al . |
Thread Tools | |
Display Modes | |
|
|