I am using MS Access 2007 and importing from MS Excel 2007.
I have a query that has some calculations and these calculations are built on other queries. This query runs great, the only parameters are BETWEEN[Begin]AND{End Date]. The problem is when I imported 78 records, the same way and from the same file that I imported the existing 1113 records in a table, I run the same query and get this error:
"This expression is typed incorrectly or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."
I have researched this error and since then have tried using the eval() to my query criteria for the date but that doesn't work. I also removed the data and imported it from a .csv file. I did an append query as well.
I don't get the error when I enter the beginning date and end date for records that already existed before importing the 78 new records. As soon as I use an end date that includes the new records, even just 1 day of those records, I get the error.
Thank you so much, I don't have any other ideas left to try.
I have a query that has some calculations and these calculations are built on other queries. This query runs great, the only parameters are BETWEEN[Begin]AND{End Date]. The problem is when I imported 78 records, the same way and from the same file that I imported the existing 1113 records in a table, I run the same query and get this error:
"This expression is typed incorrectly or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."
I have researched this error and since then have tried using the eval() to my query criteria for the date but that doesn't work. I also removed the data and imported it from a .csv file. I did an append query as well.
I don't get the error when I enter the beginning date and end date for records that already existed before importing the 78 new records. As soon as I use an end date that includes the new records, even just 1 day of those records, I get the error.
Thank you so much, I don't have any other ideas left to try.
