Crosstab Query Error No. 3070 Because Of Date Field(s), Access 2007

[adi2011]

Hi,

I have simple crosstab query that I use to pull data about how many products is sold in one day/week/month and so on. On entry form I have two critical date fields, Starting/Ending date. It all works perfect except when I put identical values in both those fields.

For example I have sold over 100 items on 4th of february 2015. year. So, in Starting/Ending date field of entry form, I put value from 04/02/2015 to 04/02/2015 in order to see how much items sold that day. Please see image attached which explains the situation.

This is the error I receive:

An error was encountered

Description: The Microsoft Office Access database engine does not recognize '' as a valid field name or expression.

Error Number: 3070

What am I doing wrong?



Thanks in advance for prompt replies!

Ceers,
Adi

This is the screenshot.

[June7]

The crosstab works if the dates are different?

Does your DocumentDate value have time parts?