how do i solve the numeric field overflow problem?

[Guest]

i've a very simple link table.. with only 2 columns of number (2 decimal).
then i create a query to sum the 2 column by dept. but i kept getting the
numeric field overflow problem! i tried to put in a ascending order sort for
the dept. it worked for the 1st run, then subsequently gave me the same
numeric field overflow prob again. wat do i need to do?? can anyone pls
help??

 

[Allen Browne]

Overflow means the value is too large for the type of field.

Open the table in design view.
What type is the field? Number? Currency? ...?

If number, look at the Size property in the lower pane.
Integer? Long? Double? Decimal?

Changing the type or size in table design is likely to stop it from
overflowing in the query.

If that does not solve the problem, please post back with the field type and
size, and the exact expression that is overflowing in the query. You may
also get some help about type-casting the field in the query from this
article:
http://members.iinet.net.au/~allenbrowne/ser-45.html