Overflow - Access 2000 Query Design 'Total'

[P]

I have a query that is pulling data from a ODBC database.

Call it Query1.

Then, Query2 is set to 'totals'. I am summing up a
certain column. The query works fine as long as there are
a limited number of records.

Currently, I need to total 1700 records. When I run it
now with that many records I get the warning 'overflow'.

I have already verified that the 'summed' column DOES NOT
contain any null values.

Please advise how I overcome the 'overflow' message.

 

[John Spencer (MVP)]

What is the Field Size of the Number fields that you are totaling? It sounds as
if it might be set to integer. If so, you will probably get an error whenever
the SUM is outside the bounds of an integer field (Plus or minus 32767). Try
changing the field size to Long Integer and see if that solves the problem.

 

[John Spencer (MVP)]

Whoops! ODBC database....

Try forcing the field type in the query.

SELECT SUM(CLng(YourFieldName)) as FieldNameTotal
FROM ....

 

[P]

I tried clng but it isn't working unfortunately.

Any other ideas?

 

[P]

I tried clng but it isn't working unfortunately.

Any other ideas?