Filter 2 unbound Textboxes

[nim180]

Hello Everyone, I have the following problem which im hoping someone can help me with. I have 2 unbound Textboxes and a filter button on a form. In Textbox1 the user inputs a start date and in Textbox2 the user inputs an end date, when the filter button is clicked it should populate a report with all the customers between and equal the 2 dates entered. The report is linked to a query, within that query i have the field dates and in the criteria of that i have the following code:

Between "&[Forms]![frmForReportOnTravel]![startdate]&" And "&[Forms]![frmForReportOnTravel]![enddate]&"

I thought the following code would do what i wanted but it doesnt actually filter all the results it only brings up 1 or 2 of the results and sometimes none when there should be. Any suggestions would be great.

Thank,
Nim

 

[TheAceMan1]

How are ya nim180 . . .

If what you shown is the actual SQL from the query, then it should be:

[blue]Between [Forms]![frmForReportOnTravel]![startdate] And [Forms]![frmForReportOnTravel]![enddate][/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[nim180]

Hey aceman thanks for the response, i orginally had:

Between [Forms]![frmForReportOnTravel]![startdate] And [Forms]![frmForReportOnTravel]![enddate]

but changed it to

Between "&[Forms]![frmForReportOnTravel]![startdate]&" And "&[Forms]![frmForReportOnTravel]![enddate]&"

i have decided to scrap this method i try another approach, thanks for the reply.

Nim