Hi, I would like to ask a question regarding my program, when I make report in the end of the month my program doesn't give me all the date I want. For instance, suppose I have to print from between #01-02-08# and #31-02-08# all the data in the #31-02-08# has not giving all the data inside that day. What I noticed is, every time I give the date the last date is not giving the complete data. I hope you understand my question. Thanks in advance for the help.:confused:

Well if you are enterring those dates, that will cause a problem since 31-02-08 is an invalid data value. There are only 29 days in February of 2008. Try setting your criteria to:

BETWEEN #01-02-08# AND #29.02.08#

First, may I call your attention to the guidelines for using the comments feature found here:

https://www.askmehelpdesk.com/feedba...ure-24951.html

If a suggestion didn't work, then ask for follow-up before giving a negative rating. I answered what was the most obvious problem. If that didn't work, then you ask for follow-up.

Another issue is your regional settings. You may have to enter the values in US date format, i.e. mm/dd/yy. But I can assure that BETWEEN startdate AND enddate works.

I am aking apologize for this mistake comment.

No problem