Access report w/SQL - exporting to Excel

  • Thread starter Thread starter Lnye
  • Start date Start date
L

Lnye

I have been running the same reports for almost a year and
all of a sudden I am getting errors when I do the same
thing that I have always done. The problems started on
Friday, June 23rd. When I run my daily report I receive
the error "Data type mismatch in criteria expression."
Nothing has changed (I even went into my backup copy that
was done a month and a half ago and I get the same
error). Then when I run my monthly report which is not
epxorting to Excel, I get the following error "This
expression is typed incorrectly, or it is too complex to
be evaluated." As I stated, I have been running these
same reports for almost a year and the reports have not
been changed, but all of a sudden I am receiving these
errors. HELP!!!! Does anyone know why I am just now
receiving these errors???
 
Lnye:

The likely problem is that you have a calculated field of some type in the
underlying query, e.g. a division or a field that uses Sum() or an Access
function such as CCur() or ABS() where the underlying data in a field that
the query uses contains a null value or text value rather than number; this
problem can occur in both the query (the likely spot) or in the report if
you use a function such as Sum() on the report. When that occurs, Access
can't evaluate the expression and the function fails with the error you are
receiving. Look at your underlying data if its a null probem, try wrapping
the field in NZ([FieldName],0) inside your expression. If its a text value
that Access is trying to evaluate as a number, then use one of the
conversion function (e.g. CLng()) to convert the text to a number value.
 
Back
Top