Hi,
I have simple crosstab query that I use to pull data about how many products is selled 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 indetical 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 was selled that day. Please see image attached which explains the situation.
This is the error I receive:
What am I doing wrong?
Thanks in advance for prompt replies!
Ceers,
Adi
I have simple crosstab query that I use to pull data about how many products is selled 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 indetical 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 was selled 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