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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Parameter on Query: Include Dates

Status
Not open for further replies.

gRegulator

Technical User
Jul 3, 2003
133
CA
Hi,

I have a date parameter placed on my query that is as follows:

Between [Forms]![frm_DateParameter]![cboStart] And [Forms]![frm_DateParameter]![cboEnd]

So, frm_DateParameter opens up, and the onclick event of the command button on the form populates the query.

The problem arises is that I would like to include the date on which the cboStart and cboEnd indicate, Not just between those dates, but including those dates as well. e.g. If i click 6/8/2005 in cboStart, Only dates from 6/9/2005 onward will be included.

Does anyone have a suggestion on how I could make this change?

Thanks!
 
My apologies to all....I read my report wrong...Sorry for the incovenience, it does include those dates!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top