The field is too small to accept...

[acent]

This one doesn't make sense to me....

I have the following recordsource of a report:

SELECT part.partNumber, part.partDesc, part.qtyPerCrate, part.stockLvl, qrySlatNeeds.need
FROM part LEFT JOIN qrySlatNeeds ON part.partID = qrySlatNeeds.partIDNeed
WHERE (((part.partType)=21));

I get the following error:
"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."

My question, since when did a select query add anything to anything, and where is it trying to add data to? I have no idea where this is coming from.

Any help is appreciated.

"God is a comedian playing to an audience too afraid to laugh."
-- Francois Marie Arouet (Voltaire)

 

[Crowley16]

you are running other queries from this select, so the other queries could be trying to add something.

or access could be giving you an error message which is total non-sense (this happens depressingly often for me...)

--------------------
Procrastinate Now!

 

[acent]

Thanks for the reply. It does include a subquery, but the subquery is a select statement as well:

SELECT billOfMaterials.partIDNeed, Sum([quantity]*[feet]) AS need
FROM billOfMaterials INNER JOIN (fabOrders INNER JOIN part ON fabOrders.partID = part.partID) ON billOfMaterials.partID = part.partID
GROUP BY billOfMaterials.partIDNeed, fabOrders.complete
HAVING (((fabOrders.complete)=False));

Any other ideas?

"God is a comedian playing to an audience too afraid to laugh."
-- Francois Marie Arouet (Voltaire)