Query Error - Field too small for data...

[Dos Equis]

Howdy all,

I'm trying to use a query to multiply a number by a currency value
using the code below.

SELECT qry_AreaByCarrier.Name, Sum(CCur([HomePay]*[Homes])) AS [Home
Pay]
FROM (qry_CurrentSubscriberCountByCarrier INNER JOIN
qry_AreasAndHomesByCarrier ON qry_CurrentSubscriberCountByCarrier.Name
= qry_AreasAndHomesByCarrier.Name) INNER JOIN (tbl_Carrier INNER JOIN
qry_AreaByCarrier ON tbl_Carrier.CID = qry_AreaByCarrier.CID) ON
qry_AreasAndHomesByCarrier.Name = qry_AreaByCarrier.Name
GROUP BY qry_AreaByCarrier.Name;

When I run this querry, I get an error saying that my field isn't big
enough for the data. One field is a long integer and the other is a
text field (Look up) that links to a currency field. I assume the
lookup has caused this problem but I'm sure there are other
possibilities as I am collecting calculated data from other queries.
Any help is greatly appreciated.

Byron