Building a calculated field in a query

[Perimeter]

Table1 has fields "Part" and "TotalMade"
Table2 has fields "Part" and "NumSubAssy"
Each field is has Data Type set to Number.

I'm building a query with a calculated field that simply multiplies TotalMade and NumSubAssy.

In the Query design I have both tables joined via "Part"
In Query Design, in the Field section of a blank field I have entered: TotalAssy:[TotalMade]*[NumSubAssy]
I keep getting a "Type mismatch in expression" when I run the query.

What am I doing wrong?

[June7]

Then the fields must not both be number type.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Bob Fitz]

Can you post a copy of the db. Just the two tables with a couple of fictitious records in each table to illustrate the problem.

[Gicu]

I think you might be using a lookup table in on of the tables for the Part (so it shows the part name but actually stores the PartID) so when you join them you have a number (PartID) joined to short text (Part).
http://access.mvps.org/access/lookupfields.htm

Cheers,