mercwonder007
IS-IT--Management
I created a query that has a date field in it. The condition is as follows: Between [Enter Begin Date] and [Enter End Date]
When I try it and put in dates that I know there is data too, it comes back blank... however, if I put in dates that are before and after the dates they show up. I am truly sorry if this does not make sense. Ex. I have a record with the date of 8-30-05 to 8-31-05 so when I run the query i'll put in begins 8-30-05 ends 8-31-05 and it comes up empty. But then i'll put in begins 8-29-05 ends 9-1-05 and it comes up. is there a way to include the typed dates in the answer?
When I try it and put in dates that I know there is data too, it comes back blank... however, if I put in dates that are before and after the dates they show up. I am truly sorry if this does not make sense. Ex. I have a record with the date of 8-30-05 to 8-31-05 so when I run the query i'll put in begins 8-30-05 ends 8-31-05 and it comes up empty. But then i'll put in begins 8-29-05 ends 9-1-05 and it comes up. is there a way to include the typed dates in the answer?