Date From Document to Order (1 Viewer)

[access2010]

My friend would like to click on a blank box that is on her Access 2003 form
= c_Master_Sales_Order_Details =
and the sentence
= Shipping will be in approximately 21 working days =

Would appear on her report
= c_Sales_Confirmation_(Blue) =

=====
Another question, can the report show a calculation of 21 days from the date the order is created.
Such as,
= Shipping will be approximately on Oct 15 2021 =

Your suggestions are appreciated
Crystal

 

[Pat Hartman]

If shipping is always 21 days, then the user shouldn't have to click on anything. Just make that the default. The wording on the report should use the NumDays field to compose the message on the report.

 

[access2010]

Pat, thank you for your note.
Depending on the product, some items are shipped in 21 day and other products are shipped in 30 days.
Once I understand how to help her for 21 day shipping, than I can use the same code for 39 days.

Could you please suggest the code that should be placed on the form?

Thank you.
Crystal

 

[theDBguy]

Hi Crystal. Have you checked into the DateAdd() function?

 

[access2010]

theDBguy, thank you for taking me to the right path.

Crystal

 

[theDBguy]

theDBguy, thank you for taking me to the right path.

Crystal

You're welcome. Glad we could assist. Good luck with your project.

 

[Pat Hartman]

You could assign groups to each part.
Group1 = 21 days
Group2 = 30 days
etc.
That gives you the flexibility to change group1 from 21 to 19 if you want to. Otherwise, you need to either default to 21 or let the user choose for each part. Which is more efficient? Grouping so you can assign the ship date or prompting the user for every order?