Re: Arithmatic overflow with AVG?

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 17:29:26 -0600

It would be better if you can post your table DDLs & the entire error
message. It is possible that you have a data type conversion error, in which
case you may want to CAST or CONVERT the datatype to appropriate compatible
one. 

-- 
Anith

Relevant Pages

  • Re: CSV file Reading Problem in VB Please HELP
    ... All you have to do is get rid of the gap, there must be a hundred different ... I have to Import some date values from a CSV file in to ACCESS 2003. ... in report error table shows that Data type conversion error ...
    (microsoft.public.vb.general.discussion)
  • Re: CSV PROBLEM
    ... I think if it were 5/09/2006 or 5/9/2006 you wouldn't have any problems but with the space before the 9 it is an invalid date. ... I have to Import some date values from a CSV file in to ACCESS 2003. ... in report error table shows that Data type conversion error ...
    (microsoft.public.dotnet.languages.vb)
  • Re: CSV file Reading Problem in VB Please HELP
    ... the Data in the CSV files as ... in report error table shows that Data type conversion error ...
    (microsoft.public.vb.general.discussion)
  • Excel import into Access97
    ... I am importing excel work sheets into access 97 and I am getting data type conversion error messages. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Loading query into a recordset...
    ... Oops! ... I got a data type conversion error on the following line: ... Disambiguate the Dim'g of prm: ...
    (microsoft.public.access.modulesdaovba)