overflow error

M

mm

I have a query that runs fine until I put >0 in the criteria. When I do that
and try to run the query I get an error "OVERFLOW". The SQL for the query is:

SELECT FullYrDeprMichele1.intAssetCost, FullYrDeprMichele1.AccumDeprec,
[intAssetCost]-[AccumDeprec] AS [Book Value],
FullYrDeprMichele1.intCostCenter, FullYrDeprMichele1.[intTag#],
FullYrDeprMichele1.ingPONumber, FullYrDeprMichele1.strLocation,
FullYrDeprMichele1.strDescription, FullYrDeprMichele1.dtmInServiceDate,
FullYrDeprMichele1.Strlife, FullYrDeprMichele1.MonthlyDeprec,
FullYrDeprMichele1.TotCurrPd
FROM FullYrDeprMichele1
WHERE (((FullYrDeprMichele1.TotCurrPd)>0));
 
G

geebee

hi,

There could be a few things wrong:

Check the datatype of the [FullYrDeprMichele1.TotCurrPd] column.
Depending on the datatype, there may need to be some quotes utilized.
check the size of your Db. Dbs approaching the 1.89GB size may generate this
error.

Hope this helps,
geebee
 
M

mm

Thank you for your response.

The datatype is set to currency. Is that it? The thing is I use this same
database with other facilities and I have the >0 in the query and it works.
It is just all of a sudden that this is a problem for this one place.

The database isn't even close to that size, so I don't think that is the
problem.

geebee said:
hi,

There could be a few things wrong:

Check the datatype of the [FullYrDeprMichele1.TotCurrPd] column.
Depending on the datatype, there may need to be some quotes utilized.
check the size of your Db. Dbs approaching the 1.89GB size may generate this
error.

Hope this helps,
geebee



mm said:
I have a query that runs fine until I put >0 in the criteria. When I do that
and try to run the query I get an error "OVERFLOW". The SQL for the query is:

SELECT FullYrDeprMichele1.intAssetCost, FullYrDeprMichele1.AccumDeprec,
[intAssetCost]-[AccumDeprec] AS [Book Value],
FullYrDeprMichele1.intCostCenter, FullYrDeprMichele1.[intTag#],
FullYrDeprMichele1.ingPONumber, FullYrDeprMichele1.strLocation,
FullYrDeprMichele1.strDescription, FullYrDeprMichele1.dtmInServiceDate,
FullYrDeprMichele1.Strlife, FullYrDeprMichele1.MonthlyDeprec,
FullYrDeprMichele1.TotCurrPd
FROM FullYrDeprMichele1
WHERE (((FullYrDeprMichele1.TotCurrPd)>0));
Click to expand...
Click to expand...
 
G

geebee

Hi,

Here is what I am thinking...
During the transition to where you are using the Db, there may have been
some data entered that does not fit the format. Check the data in that
column to make sure it's all Kosher.

Hope this helps. Also, try another number, such as 3 or something.
However, the syntax you have here of ...>0 is not the problem. This makes me
think it is something wrong with some of the data in the column.

Hope this helps.



mm said:
Thank you for your response.

The datatype is set to currency. Is that it? The thing is I use this same
database with other facilities and I have the >0 in the query and it works.
It is just all of a sudden that this is a problem for this one place.

The database isn't even close to that size, so I don't think that is the
problem.

geebee said:
hi,

There could be a few things wrong:

Check the datatype of the [FullYrDeprMichele1.TotCurrPd] column.
Depending on the datatype, there may need to be some quotes utilized.
check the size of your Db. Dbs approaching the 1.89GB size may generate this
error.

Hope this helps,
geebee



mm said:
I have a query that runs fine until I put >0 in the criteria. When I do that
and try to run the query I get an error "OVERFLOW". The SQL for the query is:

SELECT FullYrDeprMichele1.intAssetCost, FullYrDeprMichele1.AccumDeprec,
[intAssetCost]-[AccumDeprec] AS [Book Value],
FullYrDeprMichele1.intCostCenter, FullYrDeprMichele1.[intTag#],
FullYrDeprMichele1.ingPONumber, FullYrDeprMichele1.strLocation,
FullYrDeprMichele1.strDescription, FullYrDeprMichele1.dtmInServiceDate,
FullYrDeprMichele1.Strlife, FullYrDeprMichele1.MonthlyDeprec,
FullYrDeprMichele1.TotCurrPd
FROM FullYrDeprMichele1
WHERE (((FullYrDeprMichele1.TotCurrPd)>0));
Click to expand...
Click to expand...
Click to expand...
 
G

geebee

Hi,

Also...
I don't see it in your query anywhere, but if the column type is truly
"Currency", then you may be dividing by Zero somewhere. or any value that is
close to zero.



geebee said:
Hi,

Here is what I am thinking...
During the transition to where you are using the Db, there may have been
some data entered that does not fit the format. Check the data in that
column to make sure it's all Kosher.

Hope this helps. Also, try another number, such as 3 or something.
However, the syntax you have here of ...>0 is not the problem. This makes me
think it is something wrong with some of the data in the column.

Hope this helps.



mm said:
Thank you for your response.

The datatype is set to currency. Is that it? The thing is I use this same
database with other facilities and I have the >0 in the query and it works.
It is just all of a sudden that this is a problem for this one place.

The database isn't even close to that size, so I don't think that is the
problem.

geebee said:
hi,

There could be a few things wrong:

Check the datatype of the [FullYrDeprMichele1.TotCurrPd] column.
Depending on the datatype, there may need to be some quotes utilized.
check the size of your Db. Dbs approaching the 1.89GB size may generate this
error.

Hope this helps,
geebee



:

I have a query that runs fine until I put >0 in the criteria. When I do that
and try to run the query I get an error "OVERFLOW". The SQL for the query is:

SELECT FullYrDeprMichele1.intAssetCost, FullYrDeprMichele1.AccumDeprec,
[intAssetCost]-[AccumDeprec] AS [Book Value],
FullYrDeprMichele1.intCostCenter, FullYrDeprMichele1.[intTag#],
FullYrDeprMichele1.ingPONumber, FullYrDeprMichele1.strLocation,
FullYrDeprMichele1.strDescription, FullYrDeprMichele1.dtmInServiceDate,
FullYrDeprMichele1.Strlife, FullYrDeprMichele1.MonthlyDeprec,
FullYrDeprMichele1.TotCurrPd
FROM FullYrDeprMichele1
WHERE (((FullYrDeprMichele1.TotCurrPd)>0));
Click to expand...
Click to expand...
Click to expand...
 
Top