Input boxes

[ALIKONA]

I would like to make an input box that when dates are
entered in (ex. July 1, 2003 - September 30, 2003)it
would display all dates from the first date to the last
day. There is only ONE date field. So how would I go
about this, if possible?

 

[Dennis Schmidt]

Hi Alikona,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

You would need to use two fuctions that called input boxes and a "between"
statement. Criteria for date field would look something like "Between
BeginDate() AND EndDate()" (without the quotes).

Other than the control that you have over what the dialog looks like, it
would be just as easy to just enter parameters for the two arguments:

Between [Enter Beginning Date] and [Enter Ending Date]

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support