Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search By Date Range (one for the experts only ;->)

Status
Not open for further replies.

dynamodc

Programmer
Nov 15, 2001
7
GB
I need to create a view that:-

(a) Shows all records to start with

(b) Provides a facility for the user to type in a date range (i.e. From: 01-Jan-01 To: 31-Jul-01) to narrow down the range of records displayed.

Does anyone know how to do it or better still are there any example databases out there that contain such a view.

Thanks for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top