Hiya.
I have this code in a chart on one of my reports in the SQL query as a criteria.
For some reason, if i want the chart to display for example 14.12.11 > 16.12.11 I place 14/12/11 in the [txtstartdate] input box and 16/12/11 in the [txtenddate] box. The problem is that the chart starts from 15/12/11. This isn't what I want. I'm having to put 13/12/11 in [txtstartdate]. It's like it's not registering the "=" in ">=". However, the end date works fine. Can anyone tell me where i've gone wrong?
I have this code in a chart on one of my reports in the SQL query as a criteria.
Code:
>=[forms]![frmdatestuff]![txtstartdate] And <=[forms]![frmdatestuff]![txtenddate]
For some reason, if i want the chart to display for example 14.12.11 > 16.12.11 I place 14/12/11 in the [txtstartdate] input box and 16/12/11 in the [txtenddate] box. The problem is that the chart starts from 15/12/11. This isn't what I want. I'm having to put 13/12/11 in [txtstartdate]. It's like it's not registering the "=" in ">=". However, the end date works fine. Can anyone tell me where i've gone wrong?